Data compare columns not adjacent

mfc2mfc2

The SQL Data Compare results showing differences are supposed to show the two columns being compared adjacent to each other. Sometimes the columns are not adjacent to each other, making it hard to use the interface. The initial display seems to start as adjacent, but some bug appears to be causing the position to switch after going to different views, then going back to the “in both but different” view.  The relative positions keep shifting when this happens. Column srcA and dstA might start out as being at columns 1 and 2 in the results. Then dstA moves to column 3, then dstA moves to column 4, while srcA stays at column 1.

Version 13.7.3.9483 Standard

Russell D

Can you show us an example of what you're seeing?

What o/s, and what screen resolution/dpi are you using?

mfc2mfc2

I have not seen the bug in the past few days. I turned off the inclusion of identical rows, which may have impacted it. Windows 10 Enterprise 10.0.17134 Build 17134. 1920x1080 connected through a ThinkPad USB-C dock.

mfc2mfc2

I switched to a different project and the problem showed up again. This other project has the include identical rows option enabled. In the attached screenshot, all the dark blue shaded row pairs should be adjacent.

mfc2mfc2

The other bug I am seeing is that often the window showing the actual rows does not appear.

Russell D

Hi @mfc2mfc2  , sorry this never actually popped up so I didn't realise you'd come back - did you ever get to the bottom of this or did you still need help?

mfc2mfc2

This is still a problem that I sometimes see. I am now running version 13.7.16.11325

Russell D

Can you submit this to Support?

mfc2mfc2

Yes. I just ran a data compare and the column order issue appeared. The problem appears frequently, although not every time. I am comparing a SQL Server 2012 server to a 2016 server.

mfc2mfc2

I submitted a support ticket.