Copying Data from One H2 database to Another H2 database

[Sanjeev Sharma]

Folks:

I have a requirement to copy data from a few tables from an existing H2 database into a new H2 database.  I would like to know the best, most-performant way to do this.  I know backup/restore does this - but it does the entire database - my requirement to do it only a chosen set of source tables to a chosen set of destination tables in a different H2 database instance.

Any response is highly appreciated.

Thanks

[Thomas Mueller]

Hi,

A good solution is to use "create table as select...". The source table can be in a different database; you would have to create a "linked table" in the target database ("created linked table"). See also the "link_schema" function.

Regards,

Thomas