Include Identical Tables in Sync Script

ablesoftablesoft Posts: 2
I'm trying to get two databases synced but I have foriegn keys in the tables that need to sync that depend on tables that are identical so they are not included in the script. Is there a way, other than manually, to get tables to drop constraints that depend on other tables not included in the script?


  • Options
    Thanks for your post.

    This is indeed possible with SQL Data Compare.

    Can you try the option 'Drop Primary Keys, Indexes, and unique constraints'?

    Options > Synchronization Behaviour

    I hope this helps.
Sign In or Register to comment.