Automate Azure Data Sync

salilsingh-9961 346 Reputation points
2021-03-29T05:41:34.717+00:00

Hi Team,

Wanted to ask how can i automate/schedule the Azure Data sync between a Member db and a hub db?

Also, i am able to sync between member db and hub db, after syncing both the dbs, in both dbs, additional tables have been created - name of the tables starting with DataSync, how can i make sure these tables are not getting created during Azure sql data sync.

Thanks,
Salil

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,571 Reputation points
    2021-03-30T07:23:37.107+00:00

    hi @salilsingh-9961 , welcome to Microsoft QnA forum.

    You can schedule the data sync as mentioned in below screenshot. We can setup the sync frequency and it would be able to trigger accordingly.

    82607-image.png

    Another way to schedule it is through Azure Automation account. Please go through the below article for the same:

    Schedule Data Sync with Azure SQL Database use an Automation account

    Related to data sync tables these tables are needed as mentioned below:
    "The Sync Metadata Database contains the metadata and log for Data Sync. The Sync Metadata Database has to be an Azure SQL Database located in the same region as the Hub Database. The Sync Metadata Database is customer created and customer owned. You can only have one Sync Metadata Database per region and subscription. Sync Metadata Database cannot be deleted or renamed while sync groups or sync agents exist. Microsoft recommends to create a new, empty database for use as the Sync Metadata Database. Data Sync creates tables in this database and runs a frequent workload."

    Please let us know if this helps or we can discuss further.

    ----------

    If answer helps, please mark it as 'Accept answer'