How to automatically synchronize tables in different databases

Question

Small background: I work in a large company with a lot of branches. Sometimes we have several applications with separate databases on different servers. But each database contains a table with a list of branches and their relationships. I want to automatically sync these tables when one of them has changed.

My question is: what are the best methods for automatically synchronizing tables in different databases (Microsoft SQL Server 2008)?

Are there sql server functions for this? Or is an external tool a good way? Or is it better to write a small application and run it as a service or use a scheduler?

Answer 1

You can use replication (a built-in function of SQL Server) to synchronize various databases. You can also use triggers or log shipping to synchronize your tables as you add, update, or delete records:

There are some replication links here.

Here are some links for shipping logs.