migrating data

[Viet Nguyen]

Thank you all - I will remove my index files - If this doesn't work well
enough I will try the bulk insert with portable files.

Viet.

 

 

-----Original Message-----
From: powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com
[mailto:powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com] On Behalf
Of Ken Langendock
Sent: Monday, January 29, 2007 1:27 PM
To: 'Robert Edis'; powerh-l at lists.sowder.com
Subject: RE: migrating data

 

Blue is correct.

 

When we converted from HP3000 to AIX/Oracle we did the same thing.

 

Loaded the tables without any indexes and built the indexes afterwards.

It was like night and day.

 

Good luck Viet

Ken

 

-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Robert Edis
Sent: January 29, 2007 1:18 PM
To: powerh-l at lists.sowder.com
Subject: RE: migrating data


Does the recieving table have a unique index on the primary key column?
Even though you are doing an add and no update the database engine still
has to confirm that you are not entering a duplicate row if a unique PK
has been defined.  If it has and you know that the new data has a PK
that does not already exist in the table then I suggest you drop the PK
index before the load and rebuild it afterwards. 

Blue 




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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070129/db419a9c/attachment.htm