Sync two or more SQL Server 2012 databases

Question

I am working on SQL Server 2012 and my requirement is to synchronize two or more databases that exist on different servers or locations.

I have tried this with 2008 by using synchronized option appear when we right click on database name.

But did not get any solution for SQL Server 2012.

Answer 1

I have done this successfully using Service Broker on a database that needed to sync only specific data (ie. sync clients and orders between a web and a local database).

It is a bit painful to set up, but works brilliantly once in place.

That said, I wouldn't do it if you need to replicate the entire database.