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
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 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/cc6fb8b3-7e1e-49e4-a96c-72d806c95272%40googlegroups.com.