A MySQL to H2 SQL conversion library written in Java.
For the moment, you can parse a MySQL dump and convert it to H2 statements, either as an embedded library or as a standalone tool:
java -jar converter/target/mysql2h2-converter-tool-0.1-SNAPSHOT.jar input.sql > output.sql
Next steps are:
- implement other statements (SELECT, UPDATE...)
- provide samples for an on-the-fly conversion with datasource-proxy http://code.google.com/p/datasource-proxy/
Other ideas:
- look at jOOQ http://www.jooq.org/ to see if it can be used to model the DML statements and Liquibase http://www.liquibase.org/ for the DDL part
This code is provided under the MIT license.