I've only used Access with Sun JdbcOdbcDriver which IIRC does not
provide access to metadata and therefore can't be used with Cayenne
cdataport. However search on Sun site shows that a number of vendors
have at least type 3 drivers, so there is still hope:
http://developers.sun.com/product/jdbc/drivers
Andrus
On Nov 25, 2005, at 2:29 AM, James Pannozzi wrote:
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 <[EMAIL PROTECTED]> 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.
