Red Gate forums :: View topic - Factors for comparison key?
Return to www.red-gate.com RSS Feed Available

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

Factors for comparison key?

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



Joined: 16 Aug 2012
Posts: 6

PostPosted: Fri Jun 14, 2013 4:50 pm    Post subject: Factors for comparison key? Reply with quote

Hi All,

I'm comparing 2 dbs (1 SQL 200R2, 1 SQL 2008) and the 2008 one has been created using SQL Compare from the 2008 R2 one.

Now i am trying to do a Data Compare so it can deploy all the data from 2008 R2 to the 2008 empty database.

However, 128 of the tables could not be compared and this is because the comparison key was not set automatically by SQL Data Compare. Why is this? Do i need to map these manually? Is there a better way?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Fri Jun 14, 2013 5:30 pm    Post subject: Reply with quote

To match rows in the two data sources, SQL Data Compare requires:

- a comparison key for each table or view
- mappings between objects in the data sources

SQL Data Compare looks for a matching primary key or other unique identifier in each data source to use as the comparison key. This enables matching rows to be identified, and their differences to be compared.

If there is no matching primary key or other unique identifier in each data source, you will need to manually set the comparison key. This article provides information on manually setting comparison keys.

http://documentation.red-gate.com/display/SDC104/Tables+or+views+that+could+not+be+compared#Tablesorviewsthatcouldnotbecompared-Settingcomparisonkeys
_________________
Manfred Castro
Product Support
Red Gate Software
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