migrating data

[Joe Boyle]

I read somewhere that bcp is the fastest way to load into MSSQL, how about
sending a portable subfile over to the Windows box and then use it to supply
bcp.

 

  _____  

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/3390940f/attachment.html