Re: Tools for moving data from mySQL to Oracle

From: Matthias Hoys <anti_at_spam.com>
Date: Tue, 20 May 2008 16:47:36 +0200
Message-ID: <4832e4be$0$2945$ba620e4c@news.skynet.be>

"Pat" <pat.casey_at_service-now.com> wrote in message news:33db9856-8919-4aab-9652-f96a09d0384c_at_j22g2000hsf.googlegroups.com...
>
> We have a number of databases in house, including a fair number of
> mySQL databases. Some of these have grown to the point (and the data
> on them gotten critical enough), that we're considering moving them to
> Oracle (10G R2).
>
> Does anybody have any experience with tools and/or techniques to
> automate the process and have some advice to share?
>
> I'm fairly confident I could take the output of the mySQL dumps (which
> is plain text), run a perl script or something over it to fix up the
> SQL syntax, and get things to work, but I'd rather not go down that
> road if there's an existing solution out there.

Try SQL Developer with the migration workbench, it's a free product from Oracle.
See
http://www.oracle.com/technology/tech/migration/workbench/files/omwb_getstarted.html.

Matthias Received on Tue May 20 2008 - 09:47:36 CDT

This message: [ Message body ]
Next message: Fabio Zanotti: "Re: Oracle Waiting for a process to open the other end of the pipe."
Previous message: Fabio Zanotti: "Re: Oracle Waiting for a process to open the other end of the pipe."
In reply to: Pat: "Tools for moving data from mySQL to Oracle"
Next in thread: Frank van Bortel: "Re: Tools for moving data from mySQL to Oracle"
Reply: Frank van Bortel: "Re: Tools for moving data from mySQL to Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message