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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 16 Mar 2001 18:59:19 +0100
Message-ID: <tb4lrpic3llt9d_at_beta-news.demon.nl>


"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
>
>
>

Download the free Migration Wizard from http://technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 16 2001 - 18:59:19 CET

Original text of this message