Solved

MYSQL TO HSQLDB MIGRATION

Posted on 2006-10-25
2
1,720 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySqlDump not dumping triggers 1 53
mysql ide 10 48
Mysql Left Join Case 10 105
php hashing methods 3 18
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 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