Besides many dozens of fixed bugs, performance improvements,
more adherence to a standard SQL syntax and type system, there are
Some new features:
- Complete re-work of INFORMATION_SCHEMA to be more in-line with the standard
- Support for new types: ARRAY, ROW, JAVA_OBJECT
- Numerous bit, string, array and system functions implemented
- Standard-based access to generated keys
- JDBC 4.2 compliance
- Support for JDK 7 is dropped
- PageStore is discontinued
MVStore changes:
- Descending MVMap and TransactionMap cursor
- Disk space reclamation algorithm improvements
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is
not possible.
The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2.
Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.