How can we help you today? How can we help you today?

Comparison Key not set

I have two identical Databases (because of SQL Compare) and want to synchronise with SQL Data Compare. But in some tables the comparison key is not set. Why? What's the problem?

Thank you for any hints,

Michael Kriegner, ;-), Mike
informatika
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hello Mike,

    When you synchronized the databases in SQL Compare, you could have ignored indexes and not pulled the primary keys into the destination database. That's one possibility...
    Brian Donahue
    0
  • informatika
    Hello Brian,

    thanks for reply, I just found out (because with a backup and restore to another place it still didn't work), that the primary key was not set for the column. I always saw the identity( 1, 1 ), but didn't see the missing primary key symbol.

    Thanks,

    ;-), Mike
    informatika
    0

Add comment

Please sign in to leave a comment.