MySQL Forums
Forum List  »  Oracle

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

Dick,

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?

Nick

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


--
Nick Roper

Options: ReplyQuote


Subject
Views
Written By
Posted
6751
July 12, 2004 05:37AM
Re: Batch conversion of Oracle to Mysql
3587
July 29, 2004 12:13AM
3060
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.