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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Replication

Re: Oracle Replication

From: Jim Kennedy <Jim_Kennedy_at_MedicaLogic.com>
Date: Sun, 2 May 1999 13:31:26 -0700
Message-ID: <aC2X2.67092$A6.33066169@news1.teleport.com>


You could have triggers on both sides handle this for you. You would have to build all of that.
Jim
stokton_at_my-dejanews.com wrote in message <7g79s1$98k$1_at_nnrp1.dejanews.com>...
>Does anyone know of a good tool that will enable replication between an
Oracle
>database and Microsoft SQL Server. Both run on Windows NT based systems.
The
>specific requirements are:
>Transactional data housed on Oracle must be captured and moved to SQL
Server
>for a web-based application. Changes to SQL Server data must also be
captured
>and moved back to the Oracle database. Because of the particular
application,
>batch copy or bulk loading of the database changes will not be sufficient.
I
>need as close to real-time as possible. Additionally, not all data must be
>moved, so, in the interest of performance and resources, I need to subset
the
>data.
>Is there any software out there that will handle this for me?
>
>Thanks in advance.
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun May 02 1999 - 15:31:26 CDT

Original text of this message

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