homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Gold Sponsor 2015!
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

MySQL Trigger to populate An Oracle table
How to create a Mysql trigger that can populate an oracle table on a server

5+ Year Member

Msg#: 4428517 posted 11:03 am on Mar 13, 2012 (gmt 0)

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.



WebmasterWorld Senior Member 5+ Year Member

Msg#: 4428517 posted 9:35 pm on Mar 13, 2012 (gmt 0)

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.


Msg#: 4428517 posted 12:44 pm on Mar 15, 2012 (gmt 0)

You may want to explore Tungsten Replicator for this task.
Please see [tungsten-replicator.org...] for the tool itself.
There is an explanatory article at [flyingclusters.blogspot.com...]

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved