Linked Server : Syncing two tables on two SQL Servers
Have you considered Merge Replication?  This would seem to be a great solution to me.

https://docs.microsoft.com/en-us/sql/relational-databases/replication/merge/merge-replication