SQL synching 2 tables

Question

How to synch two MS SQL tables on two servers

Answer 1

Hi @Miranda, Wilander (GE HealthCare)

You can use SQL Server replication.

https://learn.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication?view=sql-server-ver16

Replication is a set of technologies that copies and distributes data and database objects from one database to another, and then synchronizes between the databases to maintain consistency.

For more about synchronizing tables in two servers, you can check the discussion in this link: https://learn.microsoft.com/en-us/answers/questions/1320965/how-to-syncronize-sql-server-tables-on-different-s. Hope it helps you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 2

Hi Miranda,

As I think you can not insert data on both sides, insert should be on one server (keeping in mind primary key/auto increment columns) while you may update on both servers.

Microsoft provides concept of updateable subscription, pls go through below link:

https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/updatable-subscriptions-for-transactional-replication?view=sql-server-ver16

Regards,