'Records not getting deleted from the receiving database

I have setup Azure Data sync as follows.

  • Two Azure databases stage and prod
  • stage has the sync group so it's the Hub
  • Sync Group conflict resolution is set to Member wins
  • prod is added as a member with sync direction To the hub
  • all tables from prod selected for sync

Once everything got provisioned and first sync ran I then went and added a record to prod and a record to stage and ran the sync manually.

What I was expecting is for the prod record to appear in stage and for the stage record to get deleted from stage as it's not in the prod What actually happened is the prod record got added to stage but the stage record didn't get deleted.

Expected behavior?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source