What are the challenges you face when working across database platforms? Take the survey

Leave foreign keys untrusted

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".


  • Options
    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
Sign In or Register to comment.