Skip to content
← SQL Data Compare

How can we improve SQL Data Compare?

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

calculated Comparision failed primary Key not found, but exists

There is an PK defined as PRIMARY KEY CLUSTERED, this Key will not be found AS comparison Key in Version 12, in Version 11 OK

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  Sam Blackburn responded  · 

Unfortunately we’re not able to reproduce this issue in our lab. If the primary keys have different names on left/right then both versions 11 and 12 report “unable to compare” but we can’t find any regression in the new major version. We will be happy to continue the investigation if you can send us a reproduction.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Sam Blackburn commented  ·   ·  Report

    Could you send some details to support@red-gate.com? It would be useful for us to have more info regarding this bug.

    I've had a go at reproducing the issue and have noticed that Compare won't automatically select a primary key as the comparison key if the primary key has a different name in the source versus the target database. This seems to be the case for both 11.6 and 12.0. You can however select the comparison key by hand.

    Kind regards,
    Sam Blackburn
    Software Developer, SQL Compare Team