ContentsIntroductionUpgrading File Format Date / Time / Timestamp General IntroductionBetween version 1.4.198 and version 2.0.0 there have been considerable changes, such that a simple update is not possible. It would have been nice to write some kind of migration tool, or auto-detect the file and upgrade. Unfortunately, this is purely a volunteer-run project, so this is just the way it has to be. Upgrading
The official way to upgrade is to do a BACKUP of your existing database
Then create a fresh database MVStore file formatThe MVStore file format we use (i.e. the default) is still mostly the same, but some subtle changes have been made to the undo logs, for the purposes of improving crash safety and also read/write performance. Date / Time / TimestampTODO - Correctness. GeneralThere are a lot more SQL keywords now. Many SQL statements feature far better support of SQL-Standard behaviour. Some old non-standard SQL syntax support has been removed. |