Re: Moving data from SQL Server to Oracle via ODBC

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com>
Date: 2000/05/16
Message-ID: <392186bc.102910046@news.alt.net>#1/1

On Tue, 16 May 2000 18:18:36 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>The only other option would be dump them to a .csv file in sqlserver
>and use sqlloader in Oracle to get the data in. sqlloader supports direct
>load, bypassing the database layer.

Thanx for the reply.

I was thinking more along the lines of linking a table directly into Oracle. I saw SQL Server (and I am about to test it) a method with which to link a table via ODBC. With all the processing being done in one database system, I would assume that it would be faster. Does Oracle support anything similar?

Brian Received on Tue May 16 2000 - 00:00:00 CDT