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