Page 1 of 1

Data Compare Comparison Key column in Mapping screen

Posted: Thu 26 Jan 2012 00:56
by cjkeller
Another question: I trying out the Data Compare. When I am on the mapping screen a number of my table names in the Comparison key column have "PK_the_name of _the _table_####" where #### seems to be a random string of letter and alpha characters.

Why is this happening? The compare seems to work just fine. Is it just a convention this program uses?

BTW - very nice program!

Thanks

Christy

Posted: Thu 26 Jan 2012 13:05
by alexa
If the name of the PRIMARY or UNIQUE key wasn't explicitly defined by the database developer, the SQL server determines it automatically.

In this case you see the automatically generated name of the primary key.

Posted: Thu 26 Jan 2012 14:52
by cjkeller
Thanks for the reply.