how can i migrate data from oracle to mysql?

there are two computers.one is installed redhat linux9 and oracle9i,the
other is installed fedora4 and mysql5.the two computers' OS are text
mode(without x window).
in this situation,Show can i migrate data from oracle to mysql?

"news.yaako.com" <mpdizxn@126.com> wrote in message
news:dq70e0$96v$1@news.yaako.com...
> there are two computers.one is installed redhat linux9 and oracle9i,the
> other is installed fedora4 and mysql5.the two computers' OS are text
> mode(without x window).
> in this situation,Show can i migrate data from oracle to mysql?

Have you looked at the MySQL Migration Toolkit?
http://dev.mysql.com/doc/migration-t.../en/index.html

I have not used it myself, but from the documentation it appears that you
could, for example, run this application on a third PC (e.g. Windows or
Linux with GUI), and connect over the network to both source (Oracle) and
destination (MySQL) databases on their respective Linux hosts. As long as
you can reach both databases with a JDBC connection, I think you're okay.

Regards,
Bill K.

Bill Karwin wrote

>I have not used it myself, but from the documentation it appears that you
>could, for example, run this application on a third PC

MySQL Migration Toolkit is the right choice for this task. However, keep in
mind that running the Migration Toolkit on a third PC will move all the
data twice: once from the source machine to the machine with the MT and
then again from there to the target machine. Hence if there is a lot of
data I strongly recommend to start MT on the target machine.

This works however only if that machine is a Windows box, because currently
MT is only available for Windows. We are working on the Linux and MacOS
port already, but this will still take a while until it is ready.

Mike
--
Mike Lischke, Software Engineer GUI
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification