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

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

24 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Adrian commented  ·   ·  Flag as inappropriate

    If support can't be added for circular dependencies, please at least fix it so that it doesn't error with "circular dependencies" that don't exist.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is preventing us from syncing production data to databases targeted at QA

  • Denis commented  ·   ·  Flag as inappropriate

    This is preventing me from syncing to a read only offsite, backup.

  • Nick Meeks commented  ·   ·  Flag as inappropriate

    This is killing our ability to sync production data to a read only reporting database. Any plans for it yet?

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is going to be show stopper for a lot of customers.
    Any progress or ETA ?

  • Anonymous commented  ·   ·  Flag as inappropriate

    This has been lingering for years - EntityFramework works easily with self-referencing tables...Sync should as well...

  • Max commented  ·   ·  Flag as inappropriate

    Any news Microsoft? I would have thought this is a pretty common issue?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Yeah, I knew it will be an obstacle at some point. It looked to good to be true.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Is there any plan to add this feature? Will anyone from Microsoft at least bother to answer the people?

  • Thierry commented  ·   ·  Flag as inappropriate

    We really need this too. It is literally a show stopper.... Would be great if Microsoft could give us a (rough) ETA on this so we can plan accordingly... Thanks!

  • Valentin Turcu commented  ·   ·  Flag as inappropriate

    This should be merged with "Add support for circular foreign key dependencies" and their votes cumulated.

  • Valentin Turcu commented  ·   ·  Flag as inappropriate

    I'd love to see this asap. This is effectively stopping me from using data sync on any of my databases.

← Previous 1

Feedback and Knowledge Base