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 Fri, 25 Nov 2005 10:23:45 GMT
I used a type III JDBC once.

It is something you launch and it goes by ODBC to M$Access and it stays
listening on a port to a Java client connection.

I think there are some evaluation drivers on internet.

> I'd like to do an MS Access to Derby port
> using Cayenne.
>
> This tool great, but I can't figure out how to point to the
> MS Access datasource.  The Docs say that
> non Java databases are supported (via ODBC?)
>
> Not really a Derby question, but has anyone mapped
> from a Microsoft Database to Derby??
>
> Exact same schema, I just want to say bye bye
> to Access cuz once in Derby the scalability goes
> way UP!!!!
>
> Thanks
> Jim Pannozzi
>
> On 11/17/05, Ahmed Mohombe <amohombe@yahoo.com> wrote:
>>
>> > 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.
>> This just sounds fantastic.
>> IMHO such a cool feature should be directly in the Cayenne Modeler in
>> the
>> menu:
>> "Migrate Data" :).
>>
>> Than by calling that menu item, to trigger those steps automatically :).
>> After that, one can put in the Derby FAQ: "How to migrate to Derby from
>> other DBs with just a few
>> clicks" :).
>>
>> Thanks in advance,
>>
>> Ahmed.
>>
>>
>



Mime
View raw message