Data Compare Comparison Key column in Mapping screen

cjkeller · Post by **cjkeller** » Thu 26 Jan 2012 00:56

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

alexa · Post by **alexa** » Thu 26 Jan 2012 13:05

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.

cjkeller · Post by **cjkeller** » Thu 26 Jan 2012 14:52

Thanks for the reply.