Re: Moving data from SQL Server to Oracle via ODBC

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/16
Message-ID: <958493790.15628.0.pluto.d4ee154e@news.demon.nl>#1/1

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.

Hth,

Sybrand Bakker, Oracle DBA

Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com> schreef in berichtnieuws 39215849.91019109_at_news.alt.net...
> I am moving data from SQL Server 7 to Oracle. I started with the
> easiest way I know. I opened Access and link tables via ODBC to both
> databases. I then wrote a function to to go through each table looking
> for matching table names plus a predicate ("dbo_" for SQL Server and
> "BRIAN_" for Oracle) and simply doing an INSERT INTO table SELECT *
> FROM table. However, with at least one table that has over 40,000
> records, this takes a short while. We are planning on importing it
> more than once as we test different things. Is there a faster method?
>
> Brian
Received on Tue May 16 2000 - 00:00:00 CDT