<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.emailstyle17
{font-family:Arial;
color:navy;}
span.EmailStyle18
{font-family:Arial;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi Glen,</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>We don’t have powerhouse on the NT
server. We are running Powerhouse on the AIX box and accessing the data on</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The Windows box. I am uploading without
the indexes and it doesn’t seem to be that much faster, next I will try bulk
upload.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks for you help.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Viet.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
powerh-l-bounces+vnguyen=wsboces.org@lists.sowder.com
[mailto:powerh-l-bounces+vnguyen=wsboces.org@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Glenn Baxter<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, January 29, 2007 6:04
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Viet Nguyen;
powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: migrating data</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>Hi Viet, </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>As per Joe's suggestion I have had much greater success unloading
to portable subfiles.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>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></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>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></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>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></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>This removes the need to manually rename elements/columns etc and
Qtp then does automatic initialisation.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>Judging from your code below; this may not be necessary.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>I found this method to be reliable and the performance quite
fast.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=maroon
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:maroon'>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></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
lang=EN-GB style='font-size:10.0pt;font-family:Verdana'>Sincerely</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Verdana><span
lang=EN-GB style='font-size:10.0pt;font-family:Verdana'>Glenn Baxter</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><strong><b><font size=4
color="#ff8040" face=Verdana><span lang=EN-GB style='font-size:13.5pt;
font-family:Verdana;color:#FF8040'>____________</span></font></b></strong></p>
<p class=MsoNormal style='margin-left:.5in'><strong><b><font size=2 color=gray
face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana;
color:gray'>Baxter IT Solutions</span></font></b></strong></p>
<p class=MsoNormal style='margin-left:.5in'><strong><b><font size=1 color=gray
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:gray'>Software that works.</span></font></b></strong></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=silver
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:silver'>456 Victoria Parade </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=silver
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:silver'>East Melbourne </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=silver
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:silver'>Victoria Australia 3002</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=silver
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:silver'>p: 03-9415-8733</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=silver
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:silver'>m: 0412-826-503</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=silver
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:silver'>f: 03-9415-8911</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><strong><b><font size=1 color=gray
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:gray'>e:</span></font></b></strong><strong><b><font size=1 color=teal
face=Verdana><span lang=EN-GB style='font-size:7.5pt;font-family:Verdana;
color:teal'> </span></font></b></strong><font size=4 color=teal><span
lang=EN-GB style='font-size:13.5pt;color:teal'><a
href="mailto:glenn@baxterit.com.au"
title="blocked::mailto:glenn@baxterit.com.au mailto:glenn@baxterit.com.au"><strong><b><font
size=1 color="#ff8040" face=Verdana
title="blocked::mailto:glenn@baxterit.com.au mailto:glenn@baxterit.com.au"><span
style='font-size:7.5pt;font-family:Verdana;color:#FF8040'>glenn@baxterit.com.au</span></font></b></strong></a></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=4 color="#ff8040"
face="Times New Roman"><span lang=EN-GB style='font-size:13.5pt;color:#FF8040'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=1 color=gray
face=Tahoma><span lang=EN-GB style='font-size:7.5pt;font-family:Tahoma;
color:gray'>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.</span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt'> </span></font></p>
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><b><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma;font-weight:bold'>From:</span></font></b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+glenn=baxterit.com.au@lists.sowder.com [mailto:powerh-l-bounces+glenn=baxterit.com.au@lists.sowder.com]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Joe Boyle<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, 30 January 2007
3:24 AM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Viet Nguyen';
powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: migrating data</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=blue face=Arial><span
lang=EN-GB style='font-size:12.0pt;font-family:Arial;color:blue'>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.</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=blue face=Arial><span
lang=EN-GB style='font-size:12.0pt;font-family:Arial;color:blue'> </span></font></p>
<div>
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;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></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>Hi ,</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>Would anyone
be able to show me how to speed up data exporting from AIX to MSSQL?</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>It takes
around 24 hours to export the data </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'>Here is my set
up:</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>1.<font
size=1 face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font color=navy><span style='color:navy'>Powerhouse
with CISAM file on AIX</span></font><font color=navy><span style='color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>2.<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font color=navy><span style='color:navy'>MSSQL DB
is on Windows box </span></font> </p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>3.<font
size=1 face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>I am using Data Direct
ODBC driver to connect to the MSSQL db from the AIX box and</span></font><font
color=navy><span style='color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>4.<font
size=1 face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>we’re on a 1gigabit
network.</span></font><font color=navy><span style='color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-indent:-.25in'><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>5.<font
size=1 face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Here is a qtp run sample:</span></font><font
color=navy><span style='color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>set process nolimit</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>commit at request</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>set input nolimit</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>use setlimit</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abadj</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abadj alias oldabadj</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abadj in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abadjdesc</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abadjdesc alias oldabadjdesc</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abadjdesc in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abadjdet</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abadjdet alias oldabadjdet</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abadjdet in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>;request abapprover</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>;access abapprover alias oldabapprover</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>;output abapprover in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abbudexp</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abbudexp alias oldabbudexp</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abbudexp in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abbudgroup</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abbudgroup alias oldabbudgroup</span></font></p>
<p class=MsoNormal style='margin-left:.75in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abbudgroup in sqldevl add</span></font></p>
</div>
</body>
</html>