[h2] How to restore a H2 database backup into a new H2 database

[Madhu M P]

Hi Folks,

Can anyone provide me the procedure to restore a H2 database backup into a
new H2 database.

Thanks,
Madhu

[Evgenij Ryazanov]

Hello.

There are to kinds of backups.

1. BACKUP command creates a ZIP archive with a new database file in it.
Such archive can be unpacked into some directory, path to unpacked file can
be specified in database connection URL. You can also rename this file if
you need it.

2. SCRIPT command creates a SQL script. If you have such backup, create a
new database and execute RUNSCIPT FROM '/path/to/file.sql'; (additional
arguments are required if file is compressed or encrypted).
http://h2database.com/html/grammar.html#runscript
The other way is to use RunScript tool:
http://h2database.com/html/tutorial.html#upgrade_backup_restore