Hi, > You can use SCRIPT TO 'filename' to export database to SQL script.
Thank you, I know, but that is not a backup in the same sense of the binary files produced by the "backup" command. >From a script file, inserts need to be executed, they may fail, circular dependencies need to be considered, encoding, etc. The file from the "backup" is the entire DB - just one file in binary mode. A "restore" operation would just swap the running file for the file the "backup" produced. Without such an operation in embedded mode, this is not possible without stopping the application server's JVM the DB runs in :( . Thank you. -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
