Good Morning. Compliments of the day. I have written a software program, which migrates/updates H2 databases automatically from older versions (e.g. 1.4) to the latest version (e.g. 2.0). * It works for single H2 databases or for all H2 databases in a folder. * It includes all relevant H2 libraries and tests automatically, which library to apply. Although you can specify the particular versions to use. * It will extract the H2 database to a compressed SQL script (with a version suffix) and create a new H2 database from that script (with a version suffix). In this regards it automates and simplifies the tools H2 already provides. * It has a command-line interface and work has started on a simple Swing UI. * It has support for the H2 metadata model and I would like to develop scripts using these meta data to find problems in the old H2 databases before migration. Samples and use cases are needed.
Usagejava -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. Examplejava -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 We have used it for migrating around 10 large H2 files successfully in the past. Although there might be many issue coming up with you particular H2 database, the only way to find and to solve them is trying out. You kind feedback will be much appreciated. Binary release: https://github.com/manticore-projects/H2MigrationTool/files/5773782/H2MigrationTool.zip Git Repo: https://github.com/manticore-projects/H2MigrationTool Please be aware, that I am no H2 developper and this has been developped outside of the H2 project. Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/0eef605a6f1fdad78c7d8e2a7b7d3025d7f67fb9.camel%40manticore-projects.com.
