<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.emailstyle17 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle18 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>Hi Viet, </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>As per Joe's suggestion I have had much greater success
unloading to portable subfiles.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>Perform a Binary transfer of the data portion (.ps) and
an ascii transfer of the dictionary portion (.psd) using wither Reflection etc
of Ftp.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>Having built a PHD on the "other side" in your case NT
Server, simply use Qtp to reload/load the SQL Server tables.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>I had built the SQL tables with underscore "_" element
names; replacing "-" naming, so; edited the dictionary (.psd) files performing a
global replace of "-" to "_".</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>This removes the need to manually rename
elements/columns etc and Qtp then does automatic
initialisation.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>Judging from your code below; this may not be
necessary.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>I found this method to be reliable and the performance
quite fast.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Verdana color=#800000 size=2><SPAN
class=046115722-29012007>You have the advantage of being able to transfer in one
process and the reload concurrently from the NT Server in another
session.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana color=#800000 size=2></FONT> </DIV>
<DIV align=left>
<DIV align=left>
<DIV align=left><FONT face=Verdana size=2>Sincerely</FONT></DIV>
<DIV align=left><FONT face=Verdana size=2></FONT></DIV>
<DIV align=left><FONT face=Verdana size=2>Glenn Baxter</FONT></DIV>
<DIV align=left><FONT color=#ff8040 size=4><STRONG><FONT face=Verdana
color=#ff8040 size=4><STRONG>____________</STRONG></FONT></STRONG></FONT></DIV>
<DIV align=left><FONT color=#ff8040 size=4><FONT face=Verdana color=#808080
size=2><STRONG>Baxter IT Solutions</STRONG></FONT></DIV>
<DIV align=left>
<DIV align=left><SPAN class=218382611-08082006><FONT face=Verdana color=#808080
size=1><STRONG>Software that works.</STRONG></FONT></SPAN></DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>456 Victoria Parade
</FONT></DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>East Melbourne
</FONT></DIV>
<DIV align=left><FONT size=1><FONT face=Verdana color=#c0c0c0>Victoria Australia
3002</FONT></FONT></DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>p:
03-9415-8733</FONT></DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>m:
0412-826-503</FONT></DIV>
<DIV align=left><FONT face=Verdana color=#c0c0c0 size=1>f:
03-9415-8911</FONT></DIV>
<DIV align=left><FONT color=#008080><FONT size=1><FONT
face=Verdana><STRONG><FONT color=#808080>e:</FONT> </STRONG></FONT></FONT><A
title="blocked::mailto:glenn@baxterit.com.au mailto:glenn@baxterit.com.au"
href="mailto:glenn@baxterit.com.au"><FONT
title="blocked::mailto:glenn@baxterit.com.au mailto:glenn@baxterit.com.au"
face=Verdana color=#ff8040
size=1><STRONG>glenn@baxterit.com.au</STRONG></FONT></A></FONT></DIV>
<DIV align=left><FONT face=Tahoma color=#808080 size=1></FONT> </DIV>
<DIV align=left><FONT face=Tahoma color=#808080 size=1>This e-mail message (and
attachments) may contain information that is confidential to Baxter IT
Solutions. If you are not the intended recipient you cannot use, distribute or
copy the message or attachments. In such a case, please notify the sender by
return e-mail immediately and erase all copies of the message and
attachments. Opinions, conclusions and other information in this message and
attachments that do not relate to the official business of Baxter IT Solutions
are neither given nor endorsed
by it.</FONT></DIV></FONT></DIV></DIV></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+glenn=baxterit.com.au@lists.sowder.com
[mailto:powerh-l-bounces+glenn=baxterit.com.au@lists.sowder.com] <B>On Behalf Of
</B>Joe Boyle<BR><B>Sent:</B> Tuesday, 30 January 2007 3:24 AM<BR><B>To:</B>
'Viet Nguyen'; powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: migrating
data<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">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.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Viet Nguyen<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> 29 January 2007 16:07<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> migrating data</SPAN></FONT><SPAN
lang=EN-US><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
lang=EN-US style="FONT-SIZE: 12pt; COLOR: navy">Hi ,</SPAN></FONT><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
lang=EN-US style="FONT-SIZE: 12pt; COLOR: navy">Would anyone be able to show me
how to speed up data exporting from AIX to MSSQL?</SPAN></FONT><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
lang=EN-US style="FONT-SIZE: 12pt; COLOR: navy">It takes around 24 hours to
export the data </SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
lang=EN-US style="FONT-SIZE: 12pt; COLOR: navy"> </SPAN></FONT><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
lang=EN-US style="FONT-SIZE: 12pt; COLOR: navy">Here is my set
up:</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=3><SPAN
lang=EN-US style="FONT-SIZE: 12pt; COLOR: navy"> </SPAN></FONT><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<OL style="MARGIN-TOP: 0cm" type=1>
<LI class=MsoNormal style="COLOR: navy; mso-list: l0 level1 lfo1"><FONT
face="Times New Roman" color=navy size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt">Powerhouse with CISAM file on
AIX<o:p></o:p></SPAN></FONT>
<LI class=MsoNormal style="mso-list: l0 level1 lfo1"><FONT
face="Times New Roman" color=navy size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt; COLOR: navy">MSSQL DB is on Windows box
</SPAN></FONT><SPAN lang=EN-US> <o:p></o:p></SPAN>
<LI class=MsoNormal style="COLOR: navy; mso-list: l0 level1 lfo1"><FONT
face=Arial color=navy size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am using Data Direct ODBC driver
to connect to the MSSQL db from the AIX box and</SPAN></FONT><SPAN
lang=EN-US><o:p></o:p></SPAN>
<LI class=MsoNormal style="COLOR: navy; mso-list: l0 level1 lfo1"><FONT
face=Arial color=navy size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">we’re on a 1gigabit
network.</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN>
<LI class=MsoNormal style="COLOR: navy; mso-list: l0 level1 lfo1"><FONT
face=Arial color=navy size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Here is a qtp run
sample:</SPAN></FONT><SPAN lang=EN-US><o:p></o:p></SPAN> </LI></OL>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">set process
nolimit<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">commit at
request<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">set input
nolimit<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">use
setlimit<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">request
abadj<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">access abadj alias
oldabadj<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">output abadj in sqldevl
add<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">request
abadjdesc<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">access abadjdesc alias
oldabadjdesc<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">output abadjdesc in sqldevl
add<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">request
abadjdet<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">access abadjdet alias
oldabadjdet<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">output abadjdet in sqldevl
add<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">;request
abapprover<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">;access abapprover alias
oldabapprover<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">;output abapprover in sqldevl
add<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">request
abbudexp<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">access abbudexp alias
oldabbudexp<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">output abbudexp in sqldevl
add<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">request
abbudgroup<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">access abbudgroup alias
oldabbudgroup<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 18pt"><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">output abbudgroup in sqldevl
add<o:p></o:p></SPAN></FONT></P></DIV></BODY></HTML>