How can we help you today? How can we help you today?

Ignore Foreign Keys

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
coavlanche
0

Comments

1 comment

Sort by
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.