How to create H2 in-memory database using H2 embedded database

Question

I'm currently writing some test cases using testng. I have a requirement to repeat same test set in H2 embedded db and in H2 in-memory db. What i want is to copy all tables and data from H2 embedded db to H2 in-memory db upon transition from one db type to another. Is it possible ? thanks in advance.

Ueli Hofstetter · Accepted Answer · 2015-03-24 14:22:21Z

1

you could use the script tool from here

http://h2database.com/javadoc/org/h2/tools/Script.html

to export the tables and data and then use runscript as descibed here

http://h2database.com/html/grammar.html#runscript

to import it in the other db

answered Mar 24, 2015 at 14:22

Ueli Hofstetter

2,5444 gold badges33 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create H2 in-memory database using H2 embedded database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related