How can we improve SQL Data Sync?

Add support for circular foreign key dependencies

Curently if the database contains circular foreign key dependencies the Azure Data Sync will not deploy the sync group reporting the error:
Cannot deploy the sync group because there is a circular foreign key dependency

313 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
You have left! (?) (thinking…)
Keith shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

25 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Brijesh Shah commented  ·   ·  Flag as inappropriate

    Really, this is really a big show stopper if we want to create High Availability on SQL Azure ... because without this, we can't setup SQL Sync Group and without that we can't do auto sync between two or more sql azure instances..

  • Anonymous commented  ·   ·  Flag as inappropriate

    we really need this too
    we have a few self-referencing tables for heirarchies like i think some other apps have
    and we have a couple actual circular reference tables too
    so without this circular reference support we cannot use sql data sync at all

  • James Backert commented  ·   ·  Flag as inappropriate

    Right now I have a table that represents a hierarchy. None of the tables make a complete circle reference, but the table does have a foreign key to itself. This seems like the best way to establish a hierarchy and should be supported

2 Next →

Feedback and Knowledge Base