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

Column Order

is there way to ignnore when there is mismatch of column orders.
I want to display only the new and not exsiting column. I don't want to get columns to be highlighted when their order is diffrent
dineshasanka
0

Comments

4 comments

Sort by
  • JonathanWatts
    You can disable the Force Column Order option in the Advanced Options dialog, this will mean that SQL Compare will ignore the differences in column order for synchronisation. However, the differences will still be highlighted in the SQL Differences panel.

    Hope this helps,

    Jonathan
    JonathanWatts
    0
  • dineshasanka
    great!
    dineshasanka
    0
  • dineshasanka
    I can't find Force Column Order option :(
    dineshasanka
    0
  • JonathanWatts
    Hi there,

    Yeah 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.

    Hope this helps,

    Regards,

    Jonathan
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.