Re: Tools for moving data from mySQL to Oracle
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 21 May 2008 14:02:04 +0200
Message-ID: <8b805$48340f3c$524b5c40$32125@cache6.tilbu1.nb.home.nl>
>
> 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
>
>
Second that. FvB Received on Wed May 21 2008 - 07:02:04 CDT
Date: Wed, 21 May 2008 14:02:04 +0200
Message-ID: <8b805$48340f3c$524b5c40$32125@cache6.tilbu1.nb.home.nl>
Matthias Hoys wrote:
> "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
>
>
Second that. FvB Received on Wed May 21 2008 - 07:02:04 CDT