How can we help you today? How can we help you today?

Force Column Order toggle not working

Hello,

I'm comparing two databases: Database_A and Database_B.

The table "MAIN_TABLE" exists in both Database_A and Database_B.

Due to the nature of the table creation mechanism I'm stuck using, the column order (As defined by "column_id" in "sys.columns" system view ) differs between Database_A and Database_B.

When I run the compare, I find that the comparison is taking the mismatched column order into account and showing a vastly different comparison. Useful in some cases but not in this one.

Is there an option to ignore the order of columns (make them line up side-by-side in the comparison view)? I found a setting to force column order and it doesn't seem to make any difference ON or OFF to the output of a compare.

I'm on version: 11.6.3.1926 professional.

p.s. Love the Easter egg game on the about screen! :-)

Many Thanks,
Simon
EnjoyinMoss
0

Comments

1 comment

Sort by
  • Andrew P
    Hey Enjoy,

    Thanks for your post and sorry you are having this issue!
    If you take a look at the column mappings are they mapped correctly? https://documentation.red-gate.com/disp ... nd+columns

    I will also follow up with you via email for more details- hope you have a great weekend!

    Best,
    Andrew P
    0

Add comment

Please sign in to leave a comment.