Column Order

dineshasanka

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

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

dineshasanka

great!

dineshasanka

I can't find Force Column Order option

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