Ignore Foreign Keys

coavlanchecoavlanche Posts: 12 New member
in Schema Compare for Oracle
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
Tagged:
· Share on Twitter

Comments

  • Eddie DEddie D Posts: 1,803 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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.