Re: Bulk loading data straight from MSSQL7 into Oracle 8i

Create the flatfiles using the MMSQL7 tables and then use Oracle's SQL*Loader to load the flatfiles. It will be much faster.

Ketan.

Philip Obbard wrote:

> Hi all,
>
> I'm in the process of merging a Coldfusion/MSSQL7 application into my firm's
> Perl/Oracle8i-based application.
>
> I'm at the final step of moving data from MSSQL7 into Oracle 8i, and I'd
> like to know what the best way is to do this. I have replicated ALL the
> tables structure from SQL7 inside our 8i DB (so I can finish converting the
> data inside Oracle); now I'm trying to move the data.
>
> I'm using the MSSQL Data Transformation Manager (DTS) to pull selected data
> from SQL7 and insert the rows into the 'duplicate' table inside Oracle 8i.
> This works, but it's very very slow (4000 rows takes about 10-12 minutes).
> I'm using the MS OLEDB library to connect to Oracle and SQL OLEDB to connect
> to SQL7.
>
> I realize I'm leaning heavily on the MSSQL tools to do this, and I'm
> wondering if there's a better way to bulk-move data from an MSSQL7 server
> into Oracle.
>
> Thanks,
> Philip
Received on Tue Mar 20 2001 - 17:41:28 CET