<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[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]-->
<title>Message</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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;}
tt
{font-family:"Courier New";}
span.emailstyle18
{font-family:Arial;
color:navy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>And just in case you don’t have PH
on the Windows side, I found that the following works with ‘MSSQLServer
2005 express’ so it should’nt be a problem to rewrite for ‘MSSQLServer
2005’,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>bcp newschema.dbo.
bcpin_table _preload in c:\path\feedbcp.ps -t ~ -c -r "|" -e
errout.log -U sa -P mypassword -S mySQLSERVERserver<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>sqlcmd
-U sa -P mypassword -S mySQLSERVERserver < feedbcp_script.sql<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>The feedbcp_script.sql
script file content is below,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>use
newone<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>go<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>begin
tran<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>update
bcpin_table set col7 = (select b.col7 from bcpin_table_preload b where
bcpin_table.col1 = b.col1 and <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>(bcpin_table.col7
is null ) or (bcpin_table.col7 != b.col7) )<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>go<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>commit<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>begin
tran<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>delete
from bcpin_table_preload where col1 in (select col1 from bcpin_table)<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>go<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>commit<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>begin
tran<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>insert
into bcpin_table select * from bcpin_table_preload<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>go<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>commit<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>begin
tran<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>delete
from bcpin_table_preload<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>go<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>commit<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:72.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>exit<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'>and use quiz code like that below to
generate the .ps file ( I tested something like this in the past and it worked
ok then )<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Arial><span style='font-size:
12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>can cle<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>set veri
error<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>set rep
nolim<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>acc
orders in axnwind<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>define
d_OrderID char*10 = ascii(OrderID ,10)<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>define
d_Freight char*14 = formatnumber ( Freight/100,
"+000000.0000","-000000.0000","0.00")<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>define
d_date date century included = sysdate<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>define
d_time char*14 = formatnumber ( d_date*10000 + systime,
"00000000 00:00")<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>define
d_sep char*1 = "~"<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>define
d_eol char*1 = "|"<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>set sub
name c:\path\feedbcp portable<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>rep summ
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_OrderID
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_sep
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_Freight
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_sep
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_freight
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_sep
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>employeeid
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_sep
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>shipvia
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_sep
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_date
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_sep
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_time
&<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>d_eol<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>bui
feedbcp<o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US 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 18:42<br>
<b><span style='font-weight:bold'>To:</span></b> Ken@Langendock.com; Robert
Edis; powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: migrating data</span></font><span
lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>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.</span></font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Viet.</span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Tahoma><span
lang=EN-US 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>Ken Langendock<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, January 29, 2007
1:27 PM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Robert Edis'; powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: migrating data</span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:blue'>Blue is correct.</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:blue'>When we converted from HP3000 to AIX/Oracle we did the same
thing.</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:blue'>Loaded the tables without any indexes and built the indexes
afterwards.</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:blue'>It was like night and day.</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:blue'>Good luck Viet</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:blue'>Ken</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Robert Edis<br>
<b><span style='font-weight:bold'>Sent:</span></b> January 29, 2007 1:18 PM<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> RE: migrating data</span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt'><br>
</span></font><font size=2 face=Arial><span lang=EN-US style='font-size:10.0pt;
font-family:Arial'>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.</span></font><span lang=EN-US>
<br>
<br>
</span><font size=2 face=Arial><span lang=EN-US style='font-size:10.0pt;
font-family:Arial'>Blue</span></font><span lang=EN-US> <br>
<br>
<br>
<br>
<br>
</span><tt><font size=2 face="Courier New"><span lang=EN-US style='font-size:
10.0pt'>From: powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</span></font></tt><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New"'><br>
<tt><font face="Courier New">[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com]
On Behalf Of</font></tt><br>
<tt><font face="Courier New">Viet Nguyen</font></tt><br>
<tt><font face="Courier New">Sent: 29 January 2007 16:07</font></tt><br>
<tt><font face="Courier New">To: powerh-l@lists.sowder.com</font></tt><br>
<tt><font face="Courier New">Subject: migrating data</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">Hi ,</font></tt><br>
<br>
<tt><font face="Courier New">Would anyone be able to show me how to speed up
data exporting from AIX to</font></tt><br>
<tt><font face="Courier New">MSSQL?</font></tt><br>
<br>
<tt><font face="Courier New">It takes around 24 hours to export the data </font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">Here is my set up:</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">1.
Powerhouse with CISAM file on AIX</font></tt><br>
<tt><font face="Courier New">2.
MSSQL DB is on Windows <st1:address w:st="on"><st1:Street w:st="on">box</st1:Street>
<br>
3</st1:address>. I am
using Data Direct ODBC driver to connect to the MSSQL db from</font></tt><br>
<tt><font face="Courier New">the AIX box and</font></tt><br>
<tt><font face="Courier New">4.
we're on a 1gigabit network.</font></tt><br>
<tt><font face="Courier New">5.
Here is a qtp run sample:</font></tt><br>
<br>
<br>
<br>
<br>
<br>
<tt><font face="Courier New">set process nolimit</font></tt><br>
<br>
<tt><font face="Courier New">commit at request</font></tt><br>
<br>
<tt><font face="Courier New">set input nolimit</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">use setlimit</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abadj</font></tt><br>
<br>
<tt><font face="Courier New">access abadj alias oldabadj</font></tt><br>
<br>
<tt><font face="Courier New">output abadj in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abadjdesc</font></tt><br>
<br>
<tt><font face="Courier New">access abadjdesc alias oldabadjdesc</font></tt><br>
<br>
<tt><font face="Courier New">output abadjdesc in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abadjdet</font></tt><br>
<br>
<tt><font face="Courier New">access abadjdet alias oldabadjdet</font></tt><br>
<br>
<tt><font face="Courier New">output abadjdet in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">;request abapprover</font></tt><br>
<br>
<tt><font face="Courier New">;access abapprover alias oldabapprover</font></tt><br>
<br>
<tt><font face="Courier New">;output abapprover in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abbudexp</font></tt><br>
<br>
<tt><font face="Courier New">access abbudexp alias oldabbudexp</font></tt><br>
<br>
<tt><font face="Courier New">output abbudexp in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abbudgroup</font></tt><br>
<br>
<tt><font face="Courier New">access abbudgroup alias oldabbudgroup</font></tt><br>
<br>
<tt><font face="Courier New">output abbudgroup in sqldevl add</font></tt><br>
<br>
<br>
</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
</body>
</html>