Re: Replicating Oracle table data on MS SQL Server 6.5 table

Mathew A. Tabler wrote:
>
> I have a requirement to keep a MS SQL Server 6.5 database table in sync
> with an Oracle 7.2.2 table.
>
> Does anyone have a suggestion on how to do this? I suspect I'll need
> Oracle DB triggers, so that when the Oracle table is updated, a
> 'transaction' is send to a SQL Server database, but the last part is
> where I need help.
>
> Thank you in advance for any suggestions.
>
> Mat Tabler
> tablerm_at_usaa.com

-- 
Oracle does their replication with AFTER ROW triggers.  Just knowing that you 
could with a decent analyst and a few good PL/SQL coders write your own.

Beware of the Multiple trigger bug.

A pharmacuetical located in France and the Phila area is doing this themselves
as well since advanced replication took so long on VMS.

______________________________________________________________________________
Michael J. Hillanbrand II                                        Dulcian, Inc.
                          Oracle Data Base Administration
Voice: 215-773-7307                                     Fax:    610-277-2966
                              mailto://mjhii_at_erols.com  
Delaware Valley Oracle Users Group              http://www.oug.com/OUG/DEVOUG/
SALTS A104, U.S. Naval Reserve     http://www_salts.icpphil.navy.mil/reserves/