homepage Welcome to WebmasterWorld Guest from 54.226.147.84
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

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
dbarasuk

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.

 

Dijkgraaf

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.

datacharmer



 
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