[ale] [OT]-ish: tool to convert ~50G Oracle DB to mySQL

Zyman, Andy zymana at hra.nyc.gov
Wed May 7 09:41:41 EDT 2003


I don't know the MySql so it might happened that the following is just
stupid:
How about writing Cprogram to do the same thing as TOAD does? You have ProC
on Oracle Side and (no idea) on MySql side...
Just a <2 cents ...


> -----Original Message-----
> From: Jonathan Rickman [mailto:jonathan at xcorps.net]
> Sent: Tuesday, May 06, 2003 9:12 PM
> To: ale at ale.org
> Subject: Re: [ale] [OT]-ish: tool to convert ~50G Oracle DB to mySQL
> 
> 
> On Tue, 6 May 2003 tslane at attbi.com wrote:
> 
> > does anyone know of any existing tools/scripts to do this 
> or do I need to dust
> > off my 3lb hammer?  ;)
> 
> Toad would be a good start. Toad can export a table as a huge insert
> statement that you could tweak. I've used this several times 
> to move data
> from Oracle to DB2 cleanly. http://www.toadsoft.com/lic_agree.html
> 
> You'll need windows though. Also, this isn't really a good 
> option for a
> database with more than 500 tables as it's largely a manual process.
> Probably beats a 3lb hammer though.
> 
> --
> Jonathan Rickman
> X Corps Security
> http://www.xcorps.net
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale





More information about the Ale mailing list