Red Gate forums :: View topic - Ignoring Diffs in Enabled vs. Disabled? Foreign Keys
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Ignoring Diffs in Enabled vs. Disabled? Foreign Keys

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mjswart



Joined: 30 Apr 2014
Posts: 3

PostPosted: Wed Apr 30, 2014 3:38 pm    Post subject: Ignoring Diffs in Enabled vs. Disabled? Foreign Keys Reply with quote

I'm running SQL Compare 10.4.8.87

I'm comparing two databases: The first is defined like this:
Code:
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:
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.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 94

PostPosted: Thu May 01, 2014 11:35 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
mjswart



Joined: 30 Apr 2014
Posts: 3

PostPosted: Mon May 05, 2014 2:01 pm    Post subject: Reply with quote

From what I understand in the support ticket, this is a known bug:
(reference SC-4077)
Back to top
View user's profile Send private message
shawnC



Joined: 22 Nov 2011
Posts: 13

PostPosted: Tue May 06, 2014 7:55 am    Post subject: Reply with quote

Bugs don't get fixed and you can't see the list of bugs either
_________________
http://stackexchange.com/users/13638/gbn
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 94

PostPosted: Tue May 06, 2014 7:14 pm    Post subject: Reply with quote

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/display/SC10/SQL+Compare+10.7+release+notes

Thanks,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group