-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Professional Azure SQL Managed Database Administration
By :

As the name suggests, Azure SQL Data Sync allows bi-directional data syncing between one or more Azure SQL databases and on-premises databases. The Azure SQL Data Sync service is free; however, there are charges for data movement into and out of an Azure SQL database.
Azure SQL Sync doesn't support SQL Managed Instance at the time of writing.
Figure 11.1 shows how data is typically synced between an Azure SQL database and an on-premises database:
Figure 11.1: Syncing between an Azure SQL database and on-premises database
Azure SQL Data Sync is based around the idea of sync groups. A sync group has a hub database and one or more member databases. The Data Sync is always from hub to member, or from member to hub. There's no data sync between two member databases.
A sync group has the following components: