From MySQL to H2

[Nitai @ SixSigns]

Hi all,

I got a customer who want to convert his MySQL DB installation to H2.
H2, has to act as a server model in this way, since remote connections
have to work as well.

As far, as I understand we have to start the H2 in server mode. How
can we import the existing tables? Is there some script or is it a
simple dump to import?

Thanks for any feedback.

Kind Regards,
Nitai

[Thotheolh]

If I am not wrong, you can dump MySQL using mysqldump. You can read
article at "http://www.devarticles.com/c/a/MySQL/Backing-Up-Your-MySQL-
Databases-With-MySQLDump/1/". to use the mysqldump. Once the dump is
created, you may have to look through the dump and personally convert
the sql statements to H2 compatible.

[Christopher Lakey]

You should be able to use SQuirreL SQL Client (http://squirrel-sql.sourceforge.net/) to copy tables between databases, as long as you install the proper JDBC drivers. I have used it to copy between SQL Server and H2, so it should work with MySQL, provided you don't have any unsupported column types, such as Geometry.

-Christopher