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
On Sat, May 23, 2009 at 3:55 PM, Nitai @ SixSigns <[email protected]>wrote: > > 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 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
