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

For moving your data a migration tool at www.ispirer.com/chyfo.html

It provides you the fastest, the easiest and the most powerful way to migrate your database into Oracle.
It allows you to extract any data from any database. It works in conjunction with Oracle SQL Loader.
[Quoted] The tool creates text files (CSV, TAB, fixed lenght), generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files for SQL Loader. Moving of LOBs are fully supported.
The tool has a lot of other features.

Best regards, Dmitry

"Ketan Shah" <shahkn_at_ch.etn.com> wrote in message news:3AB78708.44E6D545_at_ch.etn.com...
> 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 Mon Mar 26 2001 - 13:56:05 CEST