Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Mirror between MS SQL 7 and Oracle
Hi,
You can use Chyfo (http://www.ispirer.com/products/) to do this. This is a command prompt data movement tool. You can write various scripts to automate this work.
You can specify any table or SELECT statement. The tool uses SQL Loader to move data into Oracle. So it is fast as possible.
Best regards, Dmitry.
"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 - 05:54:57 CDT
![]() |
![]() |