Bug with IgnoreConstraintNames and WITH NOCHECK constraints

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Bug with IgnoreConstraintNames and WITH NOCHECK constraints

Postby JackAce » Wed Oct 16, 2013 10:33 pm

I am able to reliably reproduce an issue with the IgnoreConstraintNames option with SQL Compare 10.4.8.87.

If you specify IgnoreConstraintNames and two constraints have different WITH NOCHECK attributes set, then SQL Compare will try to create the constraint without dropping it first.

I was able to reproduce this issue on a database created from scratch with just two tables in it. Here are some images that illustrate the issue:
http://imgur.com/a/mfDmp


I also have a backup of both databases if you have any problems reproducing this.
JackAce
 
Posts: 45
Joined: Fri Jul 08, 2011 11:00 pm

Re: Bug with IgnoreConstraintNames and WITH NOCHECK constraints

Postby JackAce » Wed Oct 16, 2013 11:08 pm

FYI - As a work around, we have been specifying IgnoreWithNocheck, but this is not ideal.
JackAce
 
Posts: 45
Joined: Fri Jul 08, 2011 11:00 pm

Postby Brian Donahue » Mon Oct 21, 2013 4:26 pm

I believe this is an issue that was fixed in 10.5, but then 10.5 has been removed temporarily while a bug regarding migration scripts is being investigated. If you do not use migration scripts, can you please try using SQL Compare 10.5 and see if that solves the problem?

http://downloads.red-gate.com/checkforu ... .0.611.exe
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby JackAce » Tue Oct 22, 2013 5:11 pm

We'll probably wait until 10.5 is available with all migration issues resolved. Is there an ETA on when it will be released again?
JackAce
 
Posts: 45
Joined: Fri Jul 08, 2011 11:00 pm

Postby Brian Donahue » Wed Oct 23, 2013 10:22 am

Work starts in November, so probably mid-December, all going well.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Apr 24, 2014 3:38 pm

This issue should be fixed in version 10.7, which was released to Check for Updates yesterday.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest