Red Gate forums :: View topic - SQL Data Compare 7 - Comparison Key missing
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

SQL Data Compare 7 - Comparison Key missing

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
bluebird84



Joined: 24 Feb 2014
Posts: 7

PostPosted: Wed Mar 19, 2014 12:00 pm    Post subject: SQL Data Compare 7 - Comparison Key missing Reply with quote

Hi,

I have the following table in 2 databases. When I try to setup a data compare between them, I'm not able to set the ID column as the Comparison Key. The ID column is not even in the list (See screenshot).

Can someone please advise on how I can resolve this issue, what am I missing? Other tables with Primary Keys compare fine.

thanks


Development Database
Code:

CREATE TABLE [dbo].[udPartyTypeDefaults](
   [ID] [smallint] IDENTITY(1,1) NOT NULL,
   [PartyType] [dbo].[uCodeLookup] NULL,
   [DefaultIPType] [dbo].[uCodeLookup] NULL,
   [DefaultAssocType] [dbo].[uCodeLookup] NULL,
   [rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
 CONSTRAINT [PK_udPartyTypeDefaults] PRIMARY KEY CLUSTERED
(
   [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[udPartyTypeDefaults] ADD  CONSTRAINT [DF_udPartyTypeDefaults_rowguid]  DEFAULT (newsequentialid()) FOR [rowguid]
GO


Test Database
Code:

CREATE TABLE [dbo].[udPartyTypeDefaults](
   [ID] [smallint] IDENTITY(1,1) NOT NULL,
   [PartyType] [dbo].[uCodeLookup] NULL,
   [DefaultIPType] [dbo].[uCodeLookup] NULL,
   [DefaultAssocType] [dbo].[uCodeLookup] NULL,
   [rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
 CONSTRAINT [PK_udPartyTypeDefaults] PRIMARY KEY CLUSTERED
(
   [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[udPartyTypeDefaults] ADD  CONSTRAINT [DF_udPartyTypeDefaults_rowguid]  DEFAULT (newsequentialid()) FOR [rowguid]
GO


Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Thu Mar 20, 2014 4:07 pm    Post subject: Reply with quote

In order to select the ID column as the comparison key, you must first select "custom", then ID appears in the list of candidates. You are probably better off with the default, though, since the index is already built on the ID column and indexes are going to have better performance.

Hope this helps.
Back to top
View user's profile Send private message
bluebird84



Joined: 24 Feb 2014
Posts: 7

PostPosted: Thu Mar 20, 2014 4:19 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
In order to select the ID column as the comparison key, you must first select "custom", then ID appears in the list of candidates. You are probably better off with the default, though, since the index is already built on the ID column and indexes are going to have better performance.

Hope this helps.


Thanks for your reply. I've tried that and even after clicking Custom the ID column does not show up

Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Thu Mar 20, 2014 5:01 pm    Post subject: Reply with quote

Sorry, just realized this is v7 and I am using v10. Is it possible for you to upgrade?
Back to top
View user's profile Send private message
bluebird84



Joined: 24 Feb 2014
Posts: 7

PostPosted: Mon Mar 24, 2014 11:51 am    Post subject: Re: Reply with quote

Brian Donahue wrote:
Sorry, just realized this is v7 and I am using v10. Is it possible for you to upgrade?


I downloaded the trial version of v10 and I have exactly the same issue as in V7 when using the same project file. I then created a new project and didn't have the issue. I compared the Options and the Include Identity Column option wasn't checked. Once that was checked in v7 and v10 it mapped correctly.

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