Tools for moving data from mySQL to Oracle

From: Pat <pat.casey_at_service-now.com>
Date: Tue, 20 May 2008 07:35:59 -0700 (PDT)
Message-ID: <33db9856-8919-4aab-9652-f96a09d0384c@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. Received on Tue May 20 2008 - 09:35:59 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: fitzjarrell_at_cox.net: "Re: Help: Only one way traffic allowed for Grid control, will that work?"
Next in thread: Matthias Hoys: "Re: Tools for moving data from mySQL to Oracle"
Reply: Matthias Hoys: "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