Export Oracle Data to MYSQL Table
Not a full data migration, but I'm not sure of the best way to acheive the following:
I need to perform some calculations on an oracle 9i database and write the result to a MYSQL table. This needs to be done as an automated overnight process. Anyone done something similar before? Any suggestions.
I was thinking of using a stored proc in the Oracle database to perform the calculations and write the result set out to a data file, then running a batch file which connects to the MYSQL database and LOADS the data file. Is there an easier way to do this? I've had a look at the MYSQL Migration Workbench but it seem more of a one of export tool rather than allowing for automated processes.
Thanks in advance.
Subject
Views
Written By
Posted
Export Oracle Data to MYSQL Table
11918
April 24, 2006 07:12AM
5478
May 24, 2006 10:05AM
5091
September 25, 2006 09:37PM
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.