db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: MySQL to Derby export
Date Thu, 17 Nov 2005 14:57:24 GMT
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.


On Nov 17, 2005, at 5:44 PM, sergio@moredata.pt 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:  dskiles@docfinity.com
>> www.docfinity.com
>> -----Original Message-----
>> From: Andre Bickford [mailto:abickford@gmail.com]
>> 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

View raw message