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
