Hi, > You can try withhttp://opendbcopy.sourceforge.net/or something > similar.
This looks like a good idea if you need to script db changes and include them in your build process. Only problem is that H2 isn't in the list by default and it seems like it hasn't had any development for a few years now. If it's a once off process of converting from one db type to another, you'll probably get going faster by using SquirreL SQL. http://www.squirrelsql.org Download and install it, making sure you install the DbCopy plugin. Go to your Drivers tab, select H2 and browse for the H2 jar file. Create separate connections to your source and destination dbs. They're displayed in 2 separate tabs in SquirreL. Select all the tables from your source connection, right click and select 'Copy Table'. Now go to your destination db and expand the tree until you get to 'Table'. Right click on it and select 'Paste Table'. It should copy the tables, primary keys, foreign keys, index etc. with all data to the new db. Sometimes there are issues between databases (from h2 to postgres with blobs), but It's worked on many occasions. If there are problems with db copy plugin, you could also select your tables, right click and select 'Create Table Script' and manually modify the sql to fix the inconsistencies between dbs. There is also an option to create a data script. Just ensure you install the refactoring and all scripting plugins. If Squirrel doesn't work for some reason you could look at DdlUtils (http://db.apache.org/ddlutils), but that doesn't have a nice GUI, just xml files. I use it to generate a db structure from a source db, but programmatically copy only certain related data with transformations using Java. Hope it helps. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
