Any easy way to generate a build script from an H2 database?

database-replication h2 sql-scripts
Jérôme Verstrynge picture Jérôme Verstrynge · Mar 29, 2011 · Viewed 12.1k times · Source

let's image that one creates an H2 database with table, indexes, etc... Is there an easy way to extract a SQL script to recreate the structure of this database in another H2 database?

I am not referring to the content of the tables, indexes, etc... I am just interested in the general structure of the database to replicate it elsewhere. Thanks.

Answer

Thomas Mueller picture Thomas Mueller · Mar 29, 2011

I would use SCRIPT NODATA (returns a result set) or SCRIPT NODATA TO 'fileName'.

Related questions

How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?

Mysql Server1 is running as MASTER. Mysql Server2 is running as SLAVE. Now DB replication is happening from MASTER to SLAVE. Server2 is removed from network and re-connect it back after 1 day. After this there is mismatch in database in …

Read More
check postgres replication status

Can someone suggest the steps to check pgsql replication status and when to say replication is not happening properly? We use streaming replication with pgsql9.0 and pgsql9.4 Thanks.

Read More
SQL Server Update Trigger, Get Only modified fields

I am aware of COLUMNS_UPDATED, well I need some quick shortcut (if anyone has made, I am already making one, but if anyone can save my time, I will appriciate it) I need basicaly an XML of only updated …

Read More