Comparison Key not set

informatikainformatika Posts: 18
edited May 12, 2006 12:08PM in SQL Data Compare Previous Versions
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
· Share on Twitter

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...
    · Share on Twitter
  • informatikainformatika Posts: 18
    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
    · Share on Twitter
This discussion has been closed.