Hi all, I have a problem of how to create or find an automated script that can select daily inserts from a mysql table and then put the selected data in an other table on an Oracle database. Can someone help here?
I'll be very greatful for your help because the database is in a production and users of it are becoming impatient.
First you probably want to establish a ODBC Gateway between MYSQL and the Oracle DB. This will allow you to select from MySQL and insert into Oracle in one SQL statement. You can then have a cron job execute MySQL statements.
(Search on the bolded phrases if you need to find more details).
You will then either want a flag or a inserted/date time on your MySQl database table so you can select the records that you want to insert into Oracle. My preference would be a flag as the date/time method would involve date comparisons to the last run of the script.