H2 database db file import

Question

I have a h2 database setup in my machine. It contains some tables with data that is needed for a POC.

So the tables etc resides in the h2.db physical file in "users" directory of my machine.

I want to share my POC code to one of my friend but I cannot expose my h2 database over network.

Is there a way I can give him the db file and he can just import the tables and data into his own h2 database?

He already has h2 setup with some tables of his own. So replacing his db files with mine is not an option.

Please guide if there is a way.

Pyves · Accepted Answer · 2019-09-04 18:23:18Z

1

Copy a database into an existing one can be done using a SQL dump. H2 database grammar contain the SCRIPT function. Generated SQL has to be executed in the target database.

edited Sep 4, 2019 at 18:23

Pyves

6,5438 gold badges44 silver badges61 bronze badges

answered May 21, 2014 at 8:54

nicolas-f

5898 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

H2 database db file import

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