CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2012
HashSix
HashSix

Reputation: 105

SQL 2012 Synchronization

I need to know how I would go about synchronizing to identical databases, if changes are made in DB1, DB2 will sync with DB1 and if changes are made to DB2, DB1 will sync with DB2. The databases will do a sync every hour.

I will be using two servers with Microsoft SQL 2012.

Please may someone guide me in using the correct setup and technology.

Upvotes: 5

Views: 3237

Answers (2)

Vivek Jain
Vivek Jain

Reputation: 3889

Microsoft Sync Framework may be of use for you. Please visit the get started page.

Also, SQL Server has Sync services which allow you to connect and synchronize two databases.

SQL Server Replication is another option. You may also have a look at the Replication Developers' guide.

Upvotes: 1

dixpac
dixpac

Reputation: 533

Maybe only way to accomplish that with sql server,is Replication

http://msdn.microsoft.com/en-us/library/ms151198.aspx

Upvotes: 2

Related Questions