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?
Comments
1 comment
-
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.
Add comment
Please sign in to leave a comment.