Tutorial: Sync data from SQL Edge to Azure SQL Database by using SQL Data Sync

This tutorial shows you 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.

Prerequisites

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:

1. 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.

2. Add sync members to the sync group. For more information, see Add sync members.

3. 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:

• Data Sync Agent for Azure SQL Data Sync

• Best practices and How to troubleshoot issues with Azure SQL Data Sync

• Monitor SQL Data Sync with Azure Monitor logs

• Update the sync schema with Transact-SQL or PowerShell

Next steps

• Use PowerShell to sync between Azure SQL Database and Azure SQL Edge. In this tutorial, replace the OnPremiseServer database details with the Azure SQL Edge details.