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

Column Ordinality

Is there an option in SQL Compare that will inspect the column ordinality between two tables... so that if the destination columns are not in the same order as the source tables a script can be generated to synronize them.

Thanks!
aultmike
0

Comments

1 comment

Sort by
  • Sian.Williams
    Yes we have hidden it rather well, if you follow these steps you should be able to locate it.

    1)Start SQL Compare
    2)Select the required project
    3)Select Edit, followed by Options, followed by More Options
    4)Force column order is the first option in the More Options dialog under the Behavior header.

    I hope this helps.
    Sian.Williams
    0

Add comment

Please sign in to leave a comment.