You can also use "cdataport" Ant task available in Cayenne 1.2. It
can help you with plain tables and data. It does not implement
porting of indexes, stored procedures, triggers and views, but if you
are on MySQL, you are probably free from that "baggage" anyways ;-)
The sequence of steps is roughly the following:
* Get Cayenne 1.2M7 (http://objectstyle.org/cayenne/) - it supports
both MySQL and Derby.
* Fire up CayenneModeler, point it to MySQL and reverse engineer the
schema. Save the mapping file somewhere.
* Create an Ant build file with "cdataport" task pointing to your
mapping file and both databases (see chapter 13.4 of the user guide
bundled with Cayenne for the Ant task details).
* Run it with Ant to transfer the data.
That's it - you should have your data in Derby.
Andrus
On Nov 17, 2005, at 5:44 PM, [EMAIL PROTECTED] wrote:
Hi.
Some time ago i made a Java program that i used to convert from
Access to
Informix (With JDBC).
It is not very clear code but it worked.
Just convert the schema and copy the data.
I planned to create a project called dbconv at sourceforge to
evolve the
tool.
If someone wants to help we can create such project.
The first step could be adapt to convert from mysql to cloudscape.
Cheers
Sérgio Ferreira
I've actually tried to do this myself. I used the strictest dump
file
that I could and ended up having to hand-edit it. The big ones were
datetime/timestamp issues and autoincrement/identity issues.
Daniel Skiles
DocFinity® by Optical Image Technology, Inc.
100 Oakwood Avenue, State College, PA 16803
fax: 814.238.0011
email: [EMAIL PROTECTED]
www.docfinity.com
-----Original Message-----
From: Andre Bickford [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 17, 2005 9:31 AM
To: derby-user@db.apache.org
Subject: MySQL to Derby export
Can anyone give me some advice on the best way to export a MySQL
database to Derby? I've tried lots of different options with
mysqldump but I can't seem to get a format that I can run through
Derby.
Thanks for any help you can provide.
Andre
