Ignore Foreign Keys

coavlanche

For the life of me I can't figure out how to ignore foreign keys when doing a compare.  I've looked in the docs and tried every option I can think of and it still includes Foreign Keys, which I don't want maintained on the deployment side since the tables I'm maintaining are a subset of the actual production tables.

Thanks!
Alan Sloan

Eddie D

Hi Alan

Thank you for your forum post.

The option you are looking for is called 'Ignore constraint names'.  This options ignores the names of Primary and Secondary keys, Default, Unique and Check constraints when comparing schemas.  

Constraint names are not ignored when the schemas are deployed, hence why the Foreign Keys are included in the deployment.  There is not an option to ignore constraints for the deployment.

Many Thanks
Eddie