Include Identical Tables in Sync Script

ablesoftablesoft Posts: 2
edited November 12, 2009 5:43AM in SQL Data Compare Previous Versions
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?
· Share on Twitter

Comments

  • Chris AucklandChris Auckland Posts: 769
    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.
    Chris
    · Share on Twitter
Sign In or Register to comment.