// use the h2-1.4.196.jar/h2-1.4.200.jar to backup the current h2 db:talend_administrator to file: tac_backup.zip
java -cp .\h2-1.4.200.jar org.h2.tools.Script -url
"jdbc:h2:file:D:/Tomcats/tacdb/migrate/talend_administrator;MV_STORE=FALSE;AUTO_SERVER=TRUE;lock_timeout=15000;DEFAULT_LOCK_TIMEOUT=15000;LOCK_MODE=0"
-user tisadmin -password tisadmin -script tac_backup.zip -options compression zip
RunScriptツールを使って、新しいデータベースでバックアップを復元します:
// use the h2-2.1.210.jar to restore the backup file: tac_backup.zip to new db: talend_administrator_new
java -cp .\h2-2.1.210.jar org.h2.tools.RunScript -url
"jdbc:h2:file:D:/Tomcats/tacdb/migrate/talend_administrator_new;AUTO_SERVER=TRUE;lock_timeout=15000;DEFAULT_LOCK_TIMEOUT=15000;LOCK_MODE=0;MODE=LEGACY"
-user tisadmin -password tisadmin -script tac_backup.zip -options compression zip