Tutorial: Sync data from SQL Edge to Azure SQL Database by using SQL Data Sync
In this tutorial, you'll learn how to use an Azure SQL Data Sync sync group to incrementally sync data from Azure SQL Edge to Azure SQL Database. SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple databases in Azure SQL Database and SQL Server instances. For more information on SQL Data Sync, see Azure SQL Data Sync.
Because SQL Edge is built on the latest versions of the SQL Server Database Engine, any data synchronization mechanism that's applicable to a SQL Server instance can also be used to sync data to or from a SQL Edge instance running on an edge device.
This tutorial requires a Windows computer configured with the Data Sync Agent for Azure SQL Data Sync.
Before you begin
Create a database in Azure SQL Database. For information on how to create a database by using the Azure portal, see Create a single database in Azure SQL Database.
Create the tables and other necessary objects in your Azure SQL Database deployment.
Create the necessary tables and objects in your Azure SQL Edge deployment. For more information, see Using SQL Database DAC packages with SQL Edge.
Register the Azure SQL Edge instance with the Data Sync Agent for Azure SQL Data Sync. For more information, see Add a SQL Server database.
Sync data between a database in Azure SQL Database and SQL Edge
Setting up synchronization between a database in Azure SQL Database and a SQL Edge instance by using SQL Data Sync involves three key steps:
Use the Azure portal to create a sync group. For more information, see Create a sync group. You can use a single hub database to create multiple sync groups to synchronize data from various SQL Edge instances to one or more databases in Azure SQL Database.
Add sync members to the sync group. For more information, see Add sync members.
Set up the sync group to select the tables that will be part of the synchronization. For more information, see Configure a sync group.
After you complete the preceding steps, you'll have a sync group that includes a database in Azure SQL Database and a SQL Edge instance.
For more info about SQL Data Sync, see these articles:
- Use PowerShell to sync between Azure SQL Database and Azure SQL Edge. In this tutorial, replace the
OnPremiseServerdatabase details with the Azure SQL Edge details.