• You could use SSIS or even Merge replication by switching the roles.

    Have the destination server as the publisher with an empty table, then insert the data into the subscriber. You will need to consider retention of meta data if rows get updated (to prevent conflicts when metadata has been cleaned up)