Dear All. On Fri, 2024-11-08 at 18:47 -0800, Andrei Tokar wrote: > What's wrong with populating database to a desired state, shutting > down, copying the file, and starting H2 with a file copy.
Am I right to assume, that shutdown is not even needed: you can run export to script/backup on an open instance without interruptions, right? (Tiny detail, but it could matter.) So if I was interested in this feature, I would implement SAVEPOINT as "export to script" and RESTORE as "drop all schemas and execute script". Only questions I have: how to lock the DB while this happens and queue/stall any pending sessions -- in case of multi-user access. Cheers Andreas -- 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 visit https://groups.google.com/d/msgid/h2-database/a93f3bcf9a77e3fb913d4c16d7f41b8d80f0dcee.camel%40manticore-projects.com.
