0

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?

Z.Maz
  • 1
  • you use data sync to sync two tables, why you say " without changing anything in those 3 Tables the synchronization group"? It really confused us. Why are you affirm the sync group not work? – Leon Yue Apr 30 '21 at 01:26
  • Hi, thank you for your quick replay. Sorry, I mean without changing the schema for the two tables (not 3) let's call them table User, and table Client. The sync group works fine at the begining for couple of days, and then it stops working ( for example, if I add a new entries in the table User in DB1, it doesn't update table User in DB2 anymore -- the same for table Client in both DBs) what can be the cause of that ? Just for more info., we are devolopping a Web App and it's still on devolopment. sometimes I have to make some changes in other tables wich are not part of the sync group. – Z.Maz May 01 '21 at 10:22
  • Hi @Z.Maz, can you try manually sync the tables? – Leon Yue May 04 '21 at 02:31
  • Hi @LeonYue yes I try it, but nothing happens. – Z.Maz May 11 '21 at 13:26

0 Answers0