db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@moredata.pt
Subject Re: MySQL to Derby export
Date Thu, 17 Nov 2005 14:59:40 GMT
Great.

I give up from my project.
It seems that are severall working alternatives. :-)

Sérgio
> 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, 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
>>>
>>>
>>
>>
>>
>>
>
>



Mime
View raw message