Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sharing data between Oracle and SQL Server

Re: Sharing data between Oracle and SQL Server

From: <kuassi.mensah_at_gmail.com>
Date: 21 Dec 2006 10:19:16 -0800
Message-ID: <1166725156.800292.250560@79g2000cws.googlegroups.com>


You can use a trigger based on JDBc-Call-out that inserts data in SQL Server from Oracle. JDBC Call-out is described in chapter 4 of my book.

Kuassi,
http://db360.blogspot.com/2006/08/oracle-database-programming-using-java_01.html

Lauren Quantrell wrote:
> I have two similar tables that reside each on an Oracle database and a
> SQL Server database. I need to keep them in sync in real time. Can
> someone point me in the right direction.
> lq
Received on Thu Dec 21 2006 - 12:19:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US