Dump to SQL changes order of columns
A complete tool for creating and managing MSAccess databases.
Brought to you by:
marcieldeg
Menu
▾
▴
#103 Dump to SQL changes order of columns
Summary: Dumping a database to SQL (any dialect) does not respect the column order and instead sorts the columns alphabetically. In addition to being inconvenient in cases where the order made some sense (like having the keys first), it crashes our application that sometimes relies on a given column ordering.
Application version: 2.5.2.771
Steps to reproduce: Select Database->Tools->Dump and then any option there (for ex. SQLite)
Expected results: The generated SQL file should replicate the database, including order of the columns.
Actual results: The columns get sorted alphabetically.
Discussion
Anonymous
Fixed in release 2.5.3