question

salilsingh-9961 avatar image
0 Votes"
salilsingh-9961 asked AnuragSharma-MSFT commented

Automate Azure Data Sync

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AnuragSharma-MSFT commented

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'





image.png (24.8 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AnuragSharma-MSFT ,

In above example of scheduling azure SQL data sync, cant i mention the date and time exactly when SQL data sync will start?

Apart from above, could you please take a look in below issue -

https://docs.microsoft.com/en-us/answers/questions/337326/azure-sql-data-sync-1.html

Thanks,
Salil

0 Votes 0 ·

Hi @salilsingh-9961, thanks for replying back.

As of now we can just set the frequency but cannot set the time to start it. There is a user voice item already opened, you can upvote it and product team can plan it based on priority list.

Schedule time for Azure SQL Data Sync

I will check the other thread that you mentioned. Meanwhile if we don't have any other open queries related to this thread, we can close it. If you are fine with the details provided here, you can mark it as 'Accept Answer' which could help others having similar queries.


1 Vote 1 ·

Hi @salilsingh-9961, just wanted to follow up on this thread.

Please let us know if you have more queries here or else we can close this thread. Also if answer helped your query, please mark it as 'Accept Answer' to help others who have similar queries.

0 Votes 0 ·