On 8/3/2023 1:10 PM, Thomas Hurley wrote:
I am Product Manager for 3 products all using H2 DB and backwards compatability for updates is really an essential
This is an open-source volunteer project, not a commercial offering, so no, we
are not planning anything like that.
You are more
Noel, Andreas
I am Product Manager for 3 products all using H2 DB and backwards
compatability for updates is really an essential feature for us. All of
our products are onpremise deployments with marquee names in regulated
industries so this migration process your refer to is not ideal for
Greetings.
You will need to Export to SQL Script and Create new DB from SQL
Script.
I wrote an UI that can help you with
that: https://manticore-projects.com/H2MigrationTool/index.html
There is an online version for testing small
databases: http://h2migrationtool.manticore-projects.com/
Cheers
You are going to need to do a dump/restore for this upgrade.
Elsewhere on this group someone posted a link to a different tool that they
wrote that helps with migration - that might be useful.
I just normally code up some batch/shell files and run the backup and
restore tools.
--
You received
When we have upgraded the h2 library we get following error trying to open
the existing databases:
*Unsupported database file version or invalid file header in file
"/path/to/database.h2.mv.db" [90048-220] 90048/90048*
We use a file based database ("jdbc:h2:file:...")
Creating new databases
