2. H2MigrationTool

A software tool for migration of an old H2 database into a new H2 database format automatically.

GitHub WebSite

Usage

Migration

java -jar H2MigrationTool.jar -l <arg> -f <arg> -t <arg> -d <arg>
       [-u <arg>] [-p <arg>] [-s <arg>] [-c <arg>] -o <arg> [--force] [-h]
 -l,--lib-dir <arg>        Folder containing the H2 jar files.
 -f,--version-from <arg>   Old H2 version of the existing database.
 -t,--version-to <arg>     New H2 version to upgrade to.
 -d,--db-file <arg>        The existing H2 database (old format).
 -u,--user <arg>           The database username.
 -p,--password <arg>       The database password.
 -s,--script-file <arg>    The export script file.
 -c,--compression <arg>    The Compression Method [ZIP, GZIP]
 -o,--options <arg>        The upgrade options [VARIABLE_BINARY]
    --force                Overwrite files and continue on failure.
 -h,--help                 Show the help mesage.

Recovery

usage: java -cp H2MigrationTool.jar com.manticore.Recovery [-l <arg>] -f
       <arg> -d <arg> [-h]
 -l,--lib-dir <arg>        (Relative) Folder containing the H2 jar files.
 -f,--version-from <arg>   H2 version of the existing database.
 -d,--db-file <arg>        The (relative) existing H2 database file.
 -h,--help                 Show the help message.

Examples

java -jar H2MigrationTool.jar -l /home/are/Downloads/h2-libs                        \
                              -f 1.4.199 -t 2.0.201 -d /home/are/.manticore/riskbox \
                              -c ZIP -o VARIABLE_BINARY                             \
                              --force

java -cp H2MigrationTool.jar com.manticore.Recovery                                 \
                              -f 1.3.176 -d /home/are/.manticore/riskbox.h2.db      \

Graphical User Interface

image