Column Ordinality

aultmike

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!

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.