Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 214
HashSix Avatar asked Oct 22 '22 05:10

HashSix


1 Answers

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

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

like image 166
dixpac Avatar answered Oct 24 '22 04:10

dixpac