Data replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data replication

I am using sql server A on one end and SQL server B on another end. These servers on in different countries. These servers are connected through a leased line. The data will be modified/upgraded on both the servers. Now my question is how do I synchronise both these servers. i.e. the data modified on Server A should be replicated/transfered immediately to server B. Similarly vice versa. So at any point of time both the servers should contain the sameupdated data. Can I use VPN instead of leased line? If I write any script, will it do the replication? If that is the case the same script should be executed on both servers. pl. suggest. I am totally confused. Reards Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.