Azure SQL Database Data Sync Group


Introduction

Azure Data Sync is Microsoft service announced on June 18, 2018, and it is used to sync the data from Azure SQL to another Azure SQL Database or from SQL Server on-premises to Azure SQL Bi-Directional this services used for data sync only and you should not use it as disaster recovery or as migration tool or as read-only replica IF you need to know when you should use azure data sync check this Microsoft article, and if you need to know What is the best option for Azure SQL Database Migration, replication and read-only check this link you will find very useful articles

Azure Data Sync Concept

  • Sync Group: is one of the databases that you want to synchronize
  • Hub Database: is one the synchronize Databases
  • Member database: another database in the data sync synchronization is member databases
  • Synchronization: Happened between Hub Database and member databases this means when you do change on one of the member databases the changes reflected on the other member databases through the Hub database
Continue reading “Azure SQL Database Data Sync Group”