Thank you, these are useful tips - I found a way around the problem with them. :)
As for why I was using SCRIPT instead of BACKUP, it was actually because of transactions. I have a poorly written application that leaves lots of incomplete transactions and I wanted to deliberately exclude the transaction log from backups. :) kolmapäev, 29. aprill 2020 8:16.23 UTC+3 kirjutas Evgenij Ryazanov: > > Hello. > > SCRIPT command has many flaws, but system sequences are going to be > reimplemented together with identity columns when I or somebody else will > find time to write a better implementation. > https://github.com/h2database/h2database/issues/2339 > <https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2Fh2database%2Fh2database%2Fissues%2F2339&sa=D&sntz=1&usg=AFQjCNH8ZOBUN1M_XzVoq0sBxJiNCe-mNg> > > This command, however, is not designed for such use cases. You can use it, > but you need to execute DROP ALL OBJECTS before RUNSCRIPT FROM, or you can > delete your database, create a new empty one and execute RUNSCRIPT in it. > > H2 has BACKUP command for online backups: > https://h2database.com/html/commands.html#backup > <https://www.google.com/url?q=https%3A%2F%2Fh2database.com%2Fhtml%2Fcommands.html%23backup&sa=D&sntz=1&usg=AFQjCNGB4Mai7AKrNOiYILvBgihjazCF7w> > > Backup can be restored by unpacking of archive (with offline database) or > with Restore tool. > > -- 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/ef7a7ff8-61fe-4e82-9c4f-f020a8d2128a%40googlegroups.com.
