Share via

Query related to sync between Azure SQL Edge database and Azure SQL database

Athira Gopinath(UST,IN) 96 Reputation points
2022-12-06T07:54:28.9+00:00

Hi Team,

Objective of this work is to implement a hybrid Cloud-Edge application model where we need to sync the Azure SQL Edge database and Azure SQL database. For that purpose, we followed this "https://learn.microsoft .com/en-us/azure/azure-sql-edge/tutorial-sync-data-sync" tutorial shared by Microsoft Team.

Steps implemented are discussed as follows,

  1. Use the Azure portal to create a sync group-**SUCCESS*
    267656-syncgroup.png
  2. Add sync members to the sync group-SUCCESS
    267520-syncmember-1.png
  3. Set up the sync group to select the tables that will be part of the synchronization-SUCCESS
    267639-table.png
    267640-databases.png

Based on the tutorial, after completing the preceding steps, we'll have a sync group that includes a database in Azure SQL Database and a SQL Edge instance. But In the Tables option, database from SQL Edge instance is not listed as expected.
From what we understand from the documentation the SQL edge is considered to be an on-premises SQL server, hence we would need to add it as a member database under the “On premise” server blade in the portal. But since we have our edge runtime based on ubuntu, I don’t find any application that would serve as a sync agent for a Linux based runtime. I was wondering if there was any way to work around this problem. Any help is appreciated.

Note: SQL Edge module from Microsoft Marketplace is up and running and we are able to create database on Edge SQL, followed this tutorial “Deploy Azure SQL Edge using the Azure portal | Microsoft Learn”

Azure SQL Database
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
48 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,291 Reputation points Microsoft Employee
    2022-12-12T09:58:56.877+00:00

    Hi @Athira Gopinath(UST,IN) ,

    I have checked with the internal team.

    We recommend you to try using 3rd party OSS solutions like: ReplicaDB - Open Source Database Replication Software (osalvador.github.io) and SymmetricDS | Open Source Database Replication

    This will require a setup to be created but would work reliably.

    Please try and let us know if you are able to proceed in your use case.

    0 comments