Constraints are dropped but not re-added.

UKRoyster

SQL Compare 10.3.8

I am struggling with the script generation. After comparing two databases, I can see that the generated script drops all constraints (Foreign keys), but no where in the script are they re-added again.

Hence, if I execute the script and perform another compare, it sees that the constraints were dropped.

I am sure its a simple solution, just can't figure it out.

Andy C S

This sounds like a bug we fixed in SQL Compare 10.4 - can I get you to upgrade and see if you're still hitting it? You can upgrade for free either by selecting Help->Check for Updates, or by downloading the installer here:

ftp://support.red-gate.com/patches/SQLC ... 4.8.87.exe

Let me know if that clears anything up!

UKRoyster

Bug is fixed. Thank you Andy.

john.hunter

I'm still having this problem with version 10.4.8.87 specifically dropping primary key and not adding it back.

I'm not sure why it is dropping the primary key in the first place.

EDIT: Ok I found that if I ignore indexes in my comparison the generated script drops Primary Keys but doesn't re-add them.