Leave foreign keys untrusted

shuff1203shuff1203 Posts: 1 Bronze 1
in SQL Compare
I'm getting a warning on some tables which ultimately leads to a deploy error. The warning says to use "Leave foreign keys untrusted" under Deployment options.

If I edit the project I don't see "Deployment options". I do see "Deployment Behavior" but I don't see an options that says "Leave foreign keys untrusted".
Tagged:
· Share on Twitter

Comments

  • Rob CRob C Posts: 419 Gold 2
    I think you might be using SQL Data Compare rather than SQL Compare. Is that the case?

    I believe the option you're looking for is actually called "Skip integrity checks for foreign key constraints".
    Software Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.