Database Data Synchronization solution for multiple database servers

Database Synchronization has three policies: snapshot, merge, and transaction. the specific differences are not described. there is a lot of related information in the garden. to implement the above synchronization policy, the problem is the mutual access between multiple servers. instead of using VPN, I use a local area network client to regularly send the public IP address of the local area network to the central server, and then modify the hosts file on the server, map the machine name and IP address.

Publish and subscribe to the central server, and then register the database servers in each LAN (use the machine name to register, mssql2000 database requires SP4 patch, configure a 1433 port forwarding or enable DMZ on the LAN router ). after registration, publish the subscription. the central server will generate some snapshot scripts. Then, according to the configured scheduling policy, database data can be initialized and synchronized when bandwidth conditions permit.

The above is just a simple solution. If you have any questions about database data replication and synchronization, please join us.