How to automate Azure SQL DB Sync with other databases using ADF pipeline

Question

How to automate Azure SQL DB Sync with other databases using ADF pipeline

Sahit 20

How can I schedule the automation of Azure SQL DB Sync to other databases using an ADF pipeline? Currently, I can set a frequency, but there seems to be no option to set a start date and time. Can we initiate the Sync process through ADF pipelines?

Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2024-01-06T13:38:17.89+00:00

Hey, Can you please provide some more details as to what you mean by sync frequency? Do you want to sync whenever there is any change Or at a particular time only? Also are the other databases here where you want to sync also azure sql database?
SSingh-MSFT 16,371 Reputation points Moderator

2024-01-09T12:35:05.62+00:00

Hi Sahit •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Accepted answer

0 additional answers

Your answer

Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator

2024-01-06T13:38:17.89+00:00

Hey, Can you please provide some more details as to what you mean by sync frequency? Do you want to sync whenever there is any change Or at a particular time only? Also are the other databases here where you want to sync also azure sql database?
SSingh-MSFT 16,371 Reputation points Moderator

2024-01-09T12:35:05.62+00:00

Hi Sahit •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Maybe you can change the approach to solve the problem and use Azure Data Factory to configure an Azure Batch Job that will start the sync at the time you configure it using an Azure Az script like the one shown below:

$resourceGroupName = "<resourceGroupName>"
$serverName = "<serverName>"
$databaseName = "<databaseName>"
$syncGroupName = "MySyncGroup"
Start-AzSqlSyncGroupSync -ResourceGroupName $resourceGroupName -ServerName $serverName -DatabaseName $databaseName -SyncGroupName $syncGroupName

Share via

How to automate Azure SQL DB Sync with other databases using ADF pipeline

0 additional answers

Your answer