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

Hi,

Try Chyfo (www.ispirer.com/chyfo.html). It moves about 1 million rows a minute (in conjunction with SQLLoader).

Dmitry.

"Philip Obbard" <pobbard_at_hotresponse.com> wrote in message news:98ten1$ef5$1_at_taliesin.netcom.net.uk...
> 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 Fri Mar 16 2001 - 22:01:03 CET