Is it possible to run the script just updating the data, without dropping all tables?
I can already backup and restore, I would just like to use UPDATE OR MERGE in my schema Em quinta-feira, 8 de agosto de 2019 11:40:16 UTC-3, Evgenij Ryazanov escreveu: > > Hello. > > H2 can export a database in two formats. > > 1. Regular backup (BACKUP TO 'filename.zip'). You can unpack the generated > archive and use it as a database. > 2. Export format (SCRIPT TO 'filename.sql'). You can execute it in a new > empty database with RUNSCRIPT FROM 'filename.sql'. > > So you need to delete an existing database. If the database is not damaged > and you have an active connection to it, you can execute > SET EXCLUSIVE 2; > DROP ALL OBJECTS; > RUNSCRIPT FROM 'filename.sql'; > SET EXCLUSIVE 0; > You don't need to go to the exclusive mode and back if you don't have > other connections. > -- 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/4c2fc1cc-6287-4bbd-8278-113062292fdf%40googlegroups.com.
