BUG: order of new columns
zkent
Posts: 5
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.
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.
This discussion has been closed.
Comments
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