Leave foreign keys untrusted

shuff1203

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

Rob C

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