Re: From Oracle to MySql
Re: From Oracle to MySql
- Subject: Re: From Oracle to MySql
- From: Jean-François Veillette <email@hidden>
- Date: Wed, 15 Dec 2004 06:38:30 -0500
I have developped an WO application using an Oracle database via an
EOmodel.
Is there a way to get quickly an equivalent EOModel for MySQl ?
Yes, use prototypes. Look at the documentation for EOPrototypes,
EOJDBCPrototypes and the likes.
If you're going to constantly move from one bd to the other, this is
the most practical solution.
What are the equivalent type to use for
VARCHAR2(), DATE, CLOB,NUMBER ...
not sure, look at the doc.
Is there a simple way to migrate the data ?
yes, once you can create 2 models, one model connect to mysql, the
other one connect to oracle, and ask BulkMover to move your data for
you.
BulkMover is a wo app, available on WOCode.
There most likely some other kind of code that would do the trick, look
on freshmeat.net ('jdbcimporter' for example).
- jfv
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden