CODEWITHSUNDEEP
databaseh2
Prabal Kajla
Prabal Kajla

Reputation: 125

Discard MV-Store in existing H2 Database

Our application uses H2 DB with mv-store storage engine. Due to stability and corruption issues we've decided to discard the use of MV-Store.

Is there a way to use existing database file *.mv.db with 'mv_store=false' or 'mvcc=false' in the db url?

Upvotes: 1

Views: 917

Answers (1)

Thomas Mueller
Thomas Mueller

Reputation: 50127

No, you would need to migrate the database. You could do this by exporting to a SQL file, and then creating a new database and import from this SQL file. To create a SQL script, you could use the SCRIPT command, and to import, run the RUNSCRIPT command. There are tool available as well (Script and RunScript).

As for the corruption, I suggest to provide more details in the H2 mailing list, if you didn't do that so far. The reason is, the MVStore is supposed to be the next generation store.

Upvotes: 2

Related Questions