H2 database logo   ▲

Home
Download
Cheat Sheet

Documentation
Quickstart
Installation
Tutorial
Features
Security
Performance
Advanced

Reference
Commands
Functions
• Aggregate • Window

Data Types
SQL Grammar
System Tables
Javadoc
PDF (2 MB)

Support
FAQ
Error Analyzer
Google Group

Appendix
History
License
Build
Links
MVStore
Architecture

 

Contents

Introduction
Upgrading
File Format
Date / Time / Timestamp
General

Introduction

Between 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 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.

MVStore file format

The 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 / Timestamp

TODO - Correctness.

General

There 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.