Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1739
  • 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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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