sql azure-data sync

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  January 7, 2016 at 8:19 am

  #303610

  for syncing data between two different data centers can we use this feature in Azure. Does master db has to be on Azure or it can be on any physical server? I would like to data sync between two data centers with Azure just capturing the changes happening on the one data center and updating the data on the second data center. Is it possible to setup?

  I was referring to the below document.

  http://blogs.msdn.com/b/sync/archive/2009/12/14/how-to-synchronize-multiple-geographically-distributed-sql-server-databases-using-sql-azure-data-sync.aspx

• WorkasDBA

  SSCommitted

  Points: 1684

  More actions

  January 7, 2016 at 9:07 am

  #1850233

  Form the link information provided, yes it can set up between two data centers thru SQL Azure in the cloud. More info at https://alexandrebrisebois.wordpress.com/2013/05/23/windows-azure-sql-data-sync-is-this-service-right-for-your-database/