Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

mysql -> Oracle

1 view
Skip to first unread message

jeremy

unread,
Apr 26, 2008, 1:47:02 PM4/26/08
to
We have to look at ,igrating data from an existing system that was built
using mysql. Was in two minds where to post this to or whether to cross-
post but decided to ask here first.

Does anyone know of any utilities that will enable a mysql schema to be
loaded into Oracle (we're talking 9iR2 and/or 10gR2 here)? It doesn't
have to be sophisticated (no problem to have manual steps) but would be
great if can be achieved.

Thanks for all suggestions.

--
jeremy

Message has been deleted

Ana C. Dent

unread,
Apr 26, 2008, 3:44:29 PM4/26/08
to
jeremy <jerem...@gmail.com> wrote in news:MPG.227d7af1f7ae40e698a4e2
@news.individual.net:

If I was given this task I'd write a simple PERL program to move the data
from MYSQL to Oracle.

Do you have any MYSQL datatypes that do not cleanly map to Oracle?

steph

unread,
Apr 28, 2008, 4:50:44 AM4/28/08
to

I once transferred data from mysql to oracle using oracle's hsodbc to
define a database link from oracle to mysql. Don't know if it's the
right tool for your task, but maybe it's worth a look ...

jeremy

unread,
Apr 30, 2008, 4:39:20 PM4/30/08
to
In article <86ca5928-fb46-4823-98b9-
f6c4b9...@c58g2000hsc.googlegroups.com>, Markus Tazl says...

> maybe you'd gvve SQL Developer Migration Workbench a try. Take a look
> at http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html
>
>

Thanks you that looks interesting.


--
jeremy

jeremy

unread,
Apr 30, 2008, 4:41:30 PM4/30/08
to
In article <Xns9A8C8168CD02an...@69.28.173.184>, Ana C.
Dent says...

>
> If I was given this task I'd write a simple PERL program to move the data
> from MYSQL to Oracle.
>
>
Different servers, different providers. Ideally we'll just find a simple
method of "exporting" the MySQL schema as DDL scripts whichy are oracle-
compatible and likewise a set of insert statements per table, again
oracle-friendly.

> Do you have any MYSQL datatypes that do not cleanly map to Oracle?
>

Not sure at the moment - haven't had sight of the MySQL schema. We are
only going to load the data into a holding schema and then run
transformations to load into our application tables.


--
jeremy

jeremy

unread,
Apr 30, 2008, 4:42:00 PM4/30/08
to
In article <d4559793-657d-48ff-93df-003b1ba6b752
@a1g2000hsb.googlegroups.com>, steph says...

>
> I once transferred data from mysql to oracle using oracle's hsodbc to
> define a database link from oracle to mysql. Don't know if it's the
> right tool for your task, but maybe it's worth a look ...
>
Thanks will take a look into this as well.

--
jeremy

0 new messages