Ignoring Diffs in Enabled vs. Disabled? Foreign Keys

Compares and synchronizes SQL Server databases, backups and scripts.

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

Ignoring Diffs in Enabled vs. Disabled? Foreign Keys

Postby mjswart » Wed Apr 30, 2014 3:38 pm

I'm running SQL Compare 10.4.8.87

I'm comparing two databases: The first is defined like this:
Code: Select all
create database [Disabled]
go

use [Disabled]
go

create table A
(
   id int identity primary key
)

create table POINTER1
(
   id int identity,
   a_id int,
   constraint pk_POINTER1 primary key (id)
)
go
      
ALTER TABLE POINTER1
   WITH NOCHECK ADD CONSTRAINT FK_A_POINTER FOREIGN KEY (a_id) REFERENCES A (id)
go

ALTER TABLE POINTER1 NOCHECK CONSTRAINT FK_A_POINTER;
go


The second is defined like this:
Code: Select all
create database [Enabled-NotTrusted]
go

use [Enabled-NotTrusted]
go

create table A
(
   id int identity primary key
)

create table POINTER1
(
   id int identity,
   a_id int,
   constraint pk_POINTER1 primary key (id)
)
go

insert A default values;
insert POINTER1 (a_id) values (2);
go
      
ALTER TABLE POINTER1
   WITH NOCHECK ADD CONSTRAINT FK_A_POINTER FOREIGN KEY (a_id) REFERENCES A (id)
go


When ignore nocheck is disabled (triple negative! meaning scrutinize nocheck), these compare as different (good!)
When ignore nocheck is enabled, these compare as the same, but that's not what I expected. The docs say disabled FKs are not ignored with this option and yet it seems to be ignored.

In my project, I really would like to ignore FK trustedness, but I really want to care about FK disabledness.
mjswart
 
Posts: 3
Joined: Wed Apr 30, 2014 3:30 pm

Postby Evan Moss » Thu May 01, 2014 11:35 pm

Hello,

Just a note to anyone looking into this post -- we have a support ticket open currently and I'll post more here when I finish my investigation.

Thanks,
Evan
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm

Postby mjswart » Mon May 05, 2014 2:01 pm

From what I understand in the support ticket, this is a known bug:
(reference SC-4077)
mjswart
 
Posts: 3
Joined: Wed Apr 30, 2014 3:30 pm

Postby shawnC » Tue May 06, 2014 7:55 am

Bugs don't get fixed and you can't see the list of bugs either
shawnC
 
Posts: 13
Joined: Tue Nov 22, 2011 1:53 pm

Postby Evan Moss » Tue May 06, 2014 7:14 pm

Hello,

After updating our system, it does appear this is being discussed for a fix (SC-4077). I don't have a timeline, but it's definitely on the radar.

You're welcome to contact us periodically for updates on the bug. You can also check release notes for the list of bugs fixed each version: http://documentation.red-gate.com/displ ... ease+notes

Thanks,
Evan
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest