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, [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: [email protected] >>> 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 >>> >>> >> >> >> >> > >
