Data differences not highlighted

tswillvtswillv Posts: 2
in SQL Data Compare
Hi,

When I perform a data comparison, the differences are not highlighted in the row, as seen in this image:
https://drive.google.com/file/d/0B3SjrfAW6vB7WW9WLWFDVXA1VEk/view?usp=sharing

Both values have a light-blue cell colour, making it difficult to track the differences in the rows.

I tried the same comparison in version 11 and the difference was easily visible.

I am using SQL Data Compare version 12.2.1.4077.

Thank you
· Share on Twitter

Comments

  • Andrew FAndrew F Posts: 21
    Hello, I'm sorry to hear that you hit this problem with SQL Data Compare.

    The issue with incorrect difference highlighting was fixed in SQL Data Compare V12.2.4, so upgrading to that version should resolve the problem.

    Please let us know if you are still having problems with this after upgrading.
    · Share on Twitter
  • tswillvtswillv Posts: 2
    Very good - 12.2.4 has fixed the issue.

    Many thanks.
    · Share on Twitter
  • RichRich Posts: 2
    I also am having this problem after updating yesterday to v12.2.1.4077. When I go to Help->Check for updates, it shows no updates available. Any ideas how to fix this?

    Thanks.
    · Share on Twitter
  • mattchandlermattchandler Posts: 52 Silver 2
    Hi Rich,

    At the moment we have only released this fix on our "Frequent Updates" channel, but the fix will be on our next default release too.

    If you are interested in getting frequent updates releases you can follow the instructions at https://documentation.red-gate.com/display/SC12/Turning+on+Frequent+Updates on how to set this up
    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
    · Share on Twitter
  • RichRich Posts: 2
    That worked, thanks
    · Share on Twitter
  • ArsLongaVitaBrevisArsLongaVitaBrevis Posts: 1
    edited April 21, 2017 7:50PM
    I was having the same issue as noted above, but was hesitant to turn on Frequent Updates as I've been burned before. Nevertheless, I found there was really no other option since the issue seemed to be wholly that so long as there were *any* discrepancy in a column, the whole column's data was being highlighted as in the above's image. Same being true for any column with which *all* data was the same, it was showing "properly".

    I went from Version 12.2.1.4077 Professional to 12.3.1.43833 Professional (wasn't offered 12.2.4.x, so shouldn't there have at least been a "stable" release between the two "minor version", i.e. 12.2->12.3 changes?) and it would seem the issue is resolved as far as I can tell as well.

    I mostly posted elucidationally, but also in hopes the "fix" be pushed out to a stable release version sooner than later.
    · Share on Twitter
  • dstroutdstrout Posts: 2 New member
    I was having this issue as well. I turned on frequent updates and I'm on version 12.3.1.4383 Professional and the issue has been resolved.
    · Share on Twitter
  • JastelmerJastelmer Posts: 1
    edited April 27, 2017 6:26PM
    Hey I had similar issue, thats what brought me here. Updating to newest version fixed my problem
    Do not take life too seriously. You will never get out of it alive :)
    · Share on Twitter
Sign In or Register to comment.