MySQL Forums
Forum List  »  Oracle

Re: transfering data
Posted by: manish singh
Date: November 11, 2004 10:15PM

well trasferring data from oracle to mysql
can be achieved in a number of ways
but real-time transfer is a thing to work at

i had made a system in which i created windows batch files to
generate data files from the oracle servers and another set
of batch jobs to read the files and populate the mysql tables
also these batch jobs can be schedeuled

if you can schedule these process finely then you can have almost real time
data updation.

aprt from these there are some tools like sqlwaya, mydbpal which can help you
but again real time updation is a ?

iam not sure if one can use triggers in oracle to update a remote
mysql database but if yes then that would be the answer to your problem
isnt it

there is another thing called
oracle heterogenous connectivity which iahavent used.

Options: ReplyQuote


Subject
Views
Written By
Posted
4549
July 12, 2004 11:02PM
2746
July 24, 2004 07:57AM
2738
August 01, 2004 08:26AM
2819
August 05, 2004 10:15PM
2683
August 06, 2004 02:00AM
2665
August 09, 2004 04:15AM
Re: transfering data
2661
November 11, 2004 10:15PM
2750
November 17, 2004 12:42AM
2529
November 16, 2004 07:30PM
3172
November 17, 2004 12:27AM
2997
November 17, 2004 12:31AM
3139
November 17, 2004 01:53AM


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.