SQL Data Compare hangs when closing the comparison key/columns window

This issue occurs on multiple Microsoft OS versions. Current SQL Data Compare Version Standard.


- Open the Comparison Key window

- Close the Comparison Key window (setting a key or not, produces the same result)


- Application hangs for about 8 seconds, then shows "Not Responding" for about 4 seconds, then becomes functional again.

This is causing issues as it takes a long time to set individual comparison key fields and for some reason the key was not auto mapped between the sources. Any help would be greatly appreciated! Thanks.


Best Answer

  • Tianjiao_LiTianjiao_Li Posts: 460 Rose Gold 2
    Accepted Answer
    Hi @rbhoule

    Can you confirm if you have the same issue for all your databases?

    SQL Data Compare can automatically map the tables if it can find  a matching primary key or other unique identifier in each data source. Otherwise you'd have to specify customer comparison key manually.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?


  • rbhoulerbhoule Posts: 2 New member
    That explains the reason. I realize now that I am actually comparing a Table to a View even though the names/fields are matching, there is no primary key/unique identifier in that situation. Makes 100% sense in hindsight. Thank you.
  • Don_VDon_V Posts: 2 New member
    I have this same issue on a thread creating on 01/14/2019. The above solves the issue of not having to open the comparison key or column windows but the underlying issue of it taking 10-30 seconds to "unfreeze" still appears to be in issue in 13.6.x.
Sign In or Register to comment.