On 9 April 2010 13:37, Andreas Henningsson <andreas.hennings...@gmail.com> wrote: > Hi > > I am about to change database from SQLite to H2 in a project of mine. > > Is there any tools I can use to do i it? What is the best way to export data > from an SQLite database? >
The easiest is probably that you export your data from SQLite as an SQL dump, adapt it to the H2 dialect and use it to import your data into your H2 database. There is another solution however using the gda-sql tool from Libgda (I'm the Libgda's maintainer) where you can have more control over what get migrated from SQLite to H2 as the migration operation is done by executing some "INSERT into <an H2 table> SELECT ... FROM <an SQLite table>" statements. The idea is to use the gda-sql command to open 2 connections: one to the SQLite database, and one to the H2 database and then "bind" them together into a 3rd virtual connection in which you execute the "INSERT into..." statements. If you want to explore this way, I can give you more details. Regards, Vivien _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
