Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of sergio@moredata.pt designates
 195.23.113.20 as permitted sender)
Message-ID: <26833.194.65.141.26.1132238654.squirrel@webmail.moredata.pt>
In-Reply-To: 
     <411004C89F48004A9B41C341A515E7BA01A3D1C2@mail.oit.docfinity.com>
References: 
    <411004C89F48004A9B41C341A515E7BA01A3D1C2@mail.oit.docfinity.com>
Date: Thu, 17 Nov 2005 14:44:14 -0000 (WET)
Subject: RE: MySQL to Derby export
From: sergio@moredata.pt
To: "Derby Discussion" <derby-user@db.apache.org>
Cc: "Derby Discussion" <derby-user@db.apache.org>
User-Agent: SquirrelMail/1.4.4
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal

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
>