Re: dataexchange between oracle and mysql

From: "Ana C. Dent" <anacedent@xxxxxxxxxxx>
Date: Fri, 28 Sep 2007 14:32:56 GMT

"Micha" <pen@xxxxxx> wrote in news:5m14u5FavsftU1@xxxxxxxxxxxxx:

Hi,
i have an oracle database and a mysql database.
in both i have some same tables.
if data is changed or inserted on oracle site, then i want to apply the
changes on the mysql site to.
This should work "on the fly".

How can i realize this?

Thanks

Micha

With a Small Matter of Programming involving triggers at a minimum.

By using DBMS_PIPE or UTL_TCP on Oracle side & a custom deamon for MYSQL
just "pump" the changes across the network & implement them into MYSQL.
.

References:
- dataexchange between oracle and mysql
  - From: Micha

Prev by Date: Re: utl_smtp.rcpt and multiple emails
Next by Date: Re: Tip from mr. D.K. Burleson
Previous by thread: dataexchange between oracle and mysql
Next by thread: Tip from mr. D.K. Burleson
Index(es):
- Date
- Thread

Relevant Pages

Re: mysql + oracle
... replicate that data on mysql database in order to have it via WWW ... (apache + mysql + php). ... The only way to connect between oracle and mysql that comes to my mind ... What prevents you from accessing the oracle database from php too? ...
(comp.databases.oracle.misc)
Re: mysql + oracle
... replicate that data on mysql database in order to have it via WWW ... (apache + mysql + php). ... The only way to connect between oracle and mysql that comes to my mind ... What prevents you from accessing the oracle database from php too? ...
(comp.databases.oracle.misc)
Re: mysql + oracle
... replicate that data on mysql database in order to have it via WWW ... (apache + mysql + php). ... The only way to connect between oracle and mysql that comes to my mind ... What prevents you from accessing the oracle database from php too? ...
(comp.databases.oracle.misc)
Re: mysql + oracle
... replicate that data on mysql database in order to have it via WWW ... (apache + mysql + php). ... The only way to connect between oracle and mysql that comes to my mind ... What prevents you from accessing the oracle database from php too? ...
(comp.databases.oracle.misc)
Re: OT: How I learned to stop worrying and love the RDBMS
... not used either to replace TurboIMAGE for a migration client. ... Oracle and DB2 to replace TurboIMAGE for migration clients and our partners ... MySQL has become. ... The primary reason for our Oracle, DB2 and MS SQL Server emphasis is because ...
(comp.sys.hp.mpe)