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
4541
July 12, 2004 11:02PM
2741
July 24, 2004 07:57AM
2729
August 01, 2004 08:26AM
2813
August 05, 2004 10:15PM
2676
August 06, 2004 02:00AM
2659
August 09, 2004 04:15AM
Re: transfering data
2655
November 11, 2004 10:15PM
2741
November 17, 2004 12:42AM
2525
November 16, 2004 07:30PM
3166
November 17, 2004 12:27AM
2992
November 17, 2004 12:31AM
3133
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.