Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Mirror between MS SQL 7 and Oracle
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