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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Mirror between MS SQL 7 and Oracle

Re: Mirror between MS SQL 7 and Oracle

From: Dave Gray <david.gray_at_rdel.co.uk>
Date: Tue, 15 May 2001 17:22:27 +0100
Message-ID: <9drl4f$7ik$1@rdel.co.uk>

Set up a DTS package in SQL Server to retreive the data from Oracle. You can add scripts etc to perform record reconciliation as required

"Walter Dyck" <walter.dyck_at_singlesoft.com> wrote in message news:CZRL6.1544$35.156599_at_iguano.antw.online.be...
> I need to exchange data between an MS SQL server and Oracle. Already tried
> it with linked servers ( Linked Oracle to the SQL server) but I think this
> is not the good way to go. It is to slow.
>
> Is there a way to sync data between Oracle and SQL (just like between two
> SQL servers...)
>
> walter Dyck
>
> walter.dyck_at_online.be
>
>
Received on Tue May 15 2001 - 11:22:27 CDT

Original text of this message

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