Re: Tools for moving data from mySQL to Oracle

From: Matthias Hoys <>
Date: Tue, 20 May 2008 16:47:36 +0200
Message-ID: <4832e4be$0$2945$>

"Pat" <> wrote in message
> 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.

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

Original text of this message