migrating data

[Viet Nguyen]

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/41016bd4/attachment.htm