CODEWITHSUNDEEP
azure-devopsazure-sql-databaseazure-data-sync
Z.Maz
Z.Maz

Reputation: 1

Azure Data Sync Stop working btw two Azure SQL Databases (without showing error msg )

I use Azure Data Sync to synchronize 2 Azure SQL Databases for 2 Tables, the synchronization works always good for 6-7 days , but I think every time when I make a new Deployment in the release pipeline (in azure devops) without changing anything in those 3 Tables the synchronization group stop working.

The Synchronisation group status is still showing "Good" when the Synchronisation doesn't work. I also tried to start the synchronization manually by clicking the button Sync, but nothing happens.

Now, I have always to delete the Sync Group when its not working and create a new one for the same the tables to make everything work again.

I would like to know why the Synchronization stops working. Does anyone run into the same problem or know how to fix it?

Upvotes: 0

Views: 271

Answers (1)

Nishi
Nishi

Reputation: 1

I faced this type of issue recently. Issue does not lie with the Azure SQL Data sync.

We used to think the same, that Azure SQL Data Sync starts having issues automatically from time to time. We checked the deployment to see how it is written, and added the below parameter.

Fix: Add the following parameter in the dacpac deployment. (It is the dacpac that is getting deployed via the SQLPackage Utility.)

/p:DropDmlTriggersNotInSource=false

This Worked like a charm, and I have not faced any issues after adding this yet.

Upvotes: 0

Related Questions