Include Identical Tables in Sync Script

ablesoft

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?

Chris Auckland

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.