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.
Maybe only way to accomplish that with sql server,is Replication
http://msdn.microsoft.com/en-us/library/ms151198.aspx
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With