Solved

MYSQL TO HSQLDB MIGRATION

Posted on 2006-10-25
2
1,716 Views
Last Modified: 2008-01-09
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
Comment
Question by:raysee
2 Comments
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
ID: 17804095
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
 

Author Comment

by:raysee
ID: 17804802
ok thank you snoyes

I will try and tell you the result ...
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now