migrating data

[Greig Morrison]

I use a hybrid method in an Oracle environment, subfiles for the smaller
tables and a bulk loader for the larger tables which have a million plus
records and drop all indexes. The disadvantage of the bulk loader
(Oracle SQL Loader) is that you have to write the Control files for each
table which is a bit more work and thus the hybrid method if you have a
large number of tables. The time for the migration went from days to
hours.

Greig 

-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On
Behalf Of Viet Nguyen
Sent: 29 January 2007 16:07
To: powerh-l at lists.sowder.com
Subject: migrating data

 

Hi ,

Would anyone be able to show me how to speed up data exporting from AIX
to MSSQL?

It takes around 24 hours to export the data 

 

Here is my set up:

 

1.               Powerhouse with CISAM file on AIX
2.               MSSQL DB is on Windows box 
3.               I am using Data Direct ODBC driver to connect to the 
MSSQL db from
the AIX box and
4.               we're on a 1gigabit network.
5.               Here is a qtp run sample:

 

 

set process nolimit

commit at request

set input   nolimit

 

use setlimit

 

request abadj

access abadj alias oldabadj

output abadj in sqldevl add

 

request abadjdesc

access abadjdesc alias oldabadjdesc

output abadjdesc in sqldevl add

 

request abadjdet

access abadjdet alias oldabadjdet

output abadjdet in sqldevl add

 

;request abapprover

;access abapprover alias oldabapprover

;output abapprover in sqldevl add

 

request abbudexp

access abbudexp alias oldabbudexp

output abbudexp in sqldevl add

 

request abbudgroup

access abbudgroup alias oldabbudgroup

output abbudgroup in sqldevl add