SQL 2008 R2 Standard Replication
Posted on 2014-12-14
We have SQL Server 2008 R2 Standard edition where we have mounted our database. This server machine is connected with a leased line and authorized user can access it using static IP. In this way user can access SQL server from outside. Now our company has open a new branch office and we would like to share entire database both ends with synchronization of entire transactions. We may have new branches in future.
How could I configure TWO WAY REPLICATION to sync entire data?
Means all INSERT, UPDATE, DELETE etc process should reflect all databases.