Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1744
  • Last Modified:

MYSQL TO HSQLDB MIGRATION

Hello

I am using HSQLDB for my prototype ... but I want my data from my previous project which is in MYSQL database ...

can any one please suggest what is the easiest way to migrate the data from MYSQL to HSQLDB ?

thank you.
0
raysee
Asked:
raysee
1 Solution
 
snoyes_jwCommented:
HSQLDB has a Transfer Tool which can connect two JDBC sources.  MySQL supports JDBC, so you could use that route.

Alternatively, you could use MySQL's mysqldump program to get a text file of SQL statements, which you should be able to import into HSQLDB, perhaps with minor modifications.
0
 
rayseeAuthor Commented:
ok thank you snoyes

I will try and tell you the result ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now