BUG: order of new columns

zkentzkent Posts: 5
edited September 4, 2006 10:07AM in SQL Compare Previous Versions
Possible Bug report:

When comparing a SQL 2000 database (that contains several new columns in a particular table) with a SQL 2005 db, the new columns were added to the end of the table instead of their original position when the SQL 2005 version was updated.

Comments

  • Hi there,
    You can set an option to force the column order. (From the Options tab, click on the More Options button. The first option under behaviour is Force column order.)
    SQL compare will by default append the columns on to the end, inorder to avoid a table rebuild. However you can alter this behaviour.
    Hope this helps
    David
This discussion has been closed.