开发者

How to automatically synchronize tables in different databases

开发者 https://www.devze.com 2022-12-18 22:23 出处:网络
Little background: I\'m working in a large company with a lot of branches. We have several applications with separated databases sometimes on different servers. But every database contains a table wit

Little background: I'm working in a large company with a lot of branches. We have several applications with separated databases sometimes on different servers. But every database contains a table with a list of branches and their relationships. I want to automatically synchronize these tables when one of them changed.

My question is: what are the best practices of automatic synchronization of tables in different databases (Microsoft SQL Server 2008)?

Are there sql server features for that purpose? Or external tool is a good way? Or开发者_运维问答 it's better to write a small application and run it as a service or use the scheduler?


You can use replication (a SQL server built-in feature) to synchronize different databases. You can also use triggers or log shipping to sync your tables as records are added ,updated or deleted:

Here are some links about replication.

Here are some links about log shipping.

0

精彩评论

暂无评论...
验证码 换一张
取 消