Upgrading databases - table columns

morpheum

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

morpheum

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 Donahue

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.