MySQL Forums
Forum List  »  Oracle

Re: Batch conversion of Oracle to Mysql
Posted by: Nick Roper
Date: July 29, 2004 12:13AM


I'm guessing that there must be an Oracle equivalent of the mysqldump utility that could be used to get the data from Oracle into a text file. You could then use mysqlimport - which is a command line interface to the LOAD DATA INFILE statement in MYSQL - to load the data into MySQL. Assuming that a suitable Oracle export utility exists, then I don't see why the whole thing couldn't be run from a script as a cron job or something.

Roughly how many rows of data are we talking about?


PS - of course, if the whole thing was MySQL based, then the problem would disappear :-)

Nick Roper

Options: ReplyQuote

Written By
July 12, 2004 05:37AM
Re: Batch conversion of Oracle to Mysql
July 29, 2004 12:13AM
August 05, 2004 10:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.