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.

Alan Sloan


  • Eddie DEddie D Posts: 1,641 Rose Gold 5
    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 Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.