Upgrading databases - table columns

morpheummorpheum Posts: 5
edited February 13, 2006 12:33PM in SQL Packager Previous Versions
Hi,

I notice when generating scripts to upgrade a database and executing them the new columns for tables get appended to the end of the table in the older database.

Is it possible to request that the columns added so that table has columns in the same order for new and old database versions?

Thanks
Peter

Comments

  • looks like it is ok, i downloaded version 4.1, looked at options and noticed there is an option to keep table columns in correct order
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    Yes indeed, the force column order to be identical option has been in the software for the past few versions. This option will force a table rebuild so as to preserve the columns' ordinal positions after the synchronization.
Sign In or Register to comment.