Comparison Key not set

informatikainformatika Posts: 18
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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...
  • 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
This discussion has been closed.