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.

Prerequisites

This tutorial requires a Windows computer configured with the Data Sync Agent for Azure SQL Data Sync.

Before you begin

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:

Next steps