Column Order

dineshasankadineshasanka Posts: 208
edited January 8, 2007 6:29AM in SQL Compare Previous Versions
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

Comments

  • 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
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • I can't find Force Column Order option :(
  • 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
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
Sign In or Register to comment.