What are the challenges you face when working across database platforms? Take the survey

Column Ordinality

aultmikeaultmike Posts: 43
edited August 27, 2010 11:41AM in SQL Compare Previous Versions
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.



  • Options
    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.

    Siân Williams
    Red Gate Software
    Tel: 0800 169 7433
Sign In or Register to comment.