Re: dataexchange between oracle and mysql

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 28 Sep 2007 14:32:56 GMT
Message-ID: <sg8Li.87551$xZ2.78241@newsfe10.phx>

"Micha" <pen_at_gmx.li> wrote in news:5m14u5FavsftU1_at_mid.dfncis.de:

> 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. Received on Fri Sep 28 2007 - 09:32:56 CDT