******************************************************************
** I SERVER VER7 \tgEFA (2010N1019)*****
******************************************************************
  \tgEFA,i̎舵,gpɍۂēɒ
ׂ,QlƂȂ񓙂L̂ł,Kǂ݉B
**************************************************************
 ӎ
SQL ServeȑꍇFؕ[hɐ؂ւ܂B
 [hƂ́B
    Fؕ@SQL ServerF؂WindowsF؂WindowsF؂݂̂҉\
    [h܂B
    c[SQL ServerF؂gp邽ߍ[hɂKv܂B
    WindowsF؂OS̔F؂gp܂ZLeB͍D܂܂
    ŁA̔F؂CXg[ŋۂݒł܂B
SQL ServeȑꍇCXg[Ńf[^x[XPʂ4܂
  {ԗp̃}X^f[^x[X̓O̎؋l߂Ȃݒɂ̂,
@12:00ɋNf[^x[XobNAbv{Ȃ,
  Ot@C܂̂ŒӉB
 (O̎؋l߂ꍇ,f[^x[XꂽOgĉ
  Oɂ܂Ŗ߂o܂)
 (̐ݒ͎̃vVW[ŎsĂ܂
   sp_dboption f[^x[X,'trunc. log on chkpt.',false (؂l߂Ȃ)
   sp_dboption f[^x[X,'trunc. log on chkpt.',true  (؂l߂)
   ̍Ƃ̓OC"sa"Ŏs܂
   ̐ݒύXꍇbackup̕@ς܂̂ŒӉ
  )
@f[^x[X͈ȉ̂悤ɂȂ܂
@@{ԗp̃}X^f[^x[X-----I_VXe_REAL_MAST_@
@A{ԗp̃[Nf[^x[X-----I_VXe_REAL_WORK_@
@BeXgp̃}X^f[^x[X---I_VXe_TEST_MAST_@
@CeXgp̃[Nf[^x[X---I_VXe_TEST_WORK_@
SQL@ServerȊO̓f[^x[XPŉ^p܂B
@@PostgreSQLIBM@DB2̓XL[}PʂɂS܂B
@AOracle̓XL[}ƃ[U͕łȂ̂Ń[U[̂܂
@@p܂B
@i[Np̓[UINPOUT̂QL̂ŁAXL[}[Np
@@͂QƂȂASŋPʂɂWɂȂ܂j
**************************************************************
1) iTv

I͊SȃNCAgAT[o[̃c[łA
NłɃvO鎖ł钴ȈՌ
sc[łB
f[^f[^x[XɃe[uƂĎA
vO͂rpkƌĂԌō܂B
vO͂Ȃŝōŏ镨ɂ͌܂B

1D1)Iɂ͎̋@\L܂B
(1)j[\,vO(Wu)sł܂B
   ŏ̃j[ZAAAZZZZ܂ł̍܂B
@@iCXg[_łzzzz1łAʂ͂ŏ\łj
   S3Kw1̃j[40ڂ܂ŕ\܂B
@@iSO~SO~SOUSOOOWułj
   j[̓T[o[̃[Vif[^x[XɋL܂B
(2)vO(Wu)ɔF؂ݒł܂B
   gp҂ƃpX[hŃ`FbN܂B
   @ŒNłgpłݒ肪o܂B
 @Agp҂o^Ύgpoݒ肪ł܂B@@
   BgpҖɔF؎w肪o܂B
 @CǗ҂̂ݎgpłݒ肪ł܂B
@@gp҂͋ƌĂԂS̉pݒ肳
@@@A͈̔͂̃e[uƃvÔ݈Ƃo܂B
@@̓CXg[_ZZZZiSĂ̋𗘗p\ȍōj
@@ZZZYiʏ̗pҁj̐ݒ肪Ă܂B
(3)Jxc[Ă܂B
   Jxc[IōĂ܂BivO̎QlɂȂ܂j
   (j[,vO,e[u(f[^x[X)̍쐬,C,폜ł܂)
   vOT[o[̃[Vif[^x[XɋL܂B
(4)ғɂXPW[ĂԋNWu܂B

1D2)I͎̓܂B
iWbN̓c[őΉĂ̂ŒNłȒPɍ܂j
(1)SQL{Ƃs̕IŃT|[g܂B
(2)o͗p(OUTPUT)Ɠ͗p(INPUT)̃WbNWŒ񋟂܂B
(3)ʑ̃WbN͑gݍ܂Ă̂ō쐬svłB
(4)͗p̓e[u̍폜(1),쐬(2),C(3)Wőgݍ܂B
(5)ʕ\f[^1I(0)Ď̃vOsł܂B
(6)e[uf[^bru`̃t@CɗƂƂł܂B
(7)EXCEL̃vOʃvZXƂċNł܂B
(8)T[o[̃t@C𑗎Mł܂B(,fBNg)
(9)T[o[̃ob`t@Csł܂B
(10)ǂقǂ̂Ƃ\łB
**************************************************************
2)CXg[̏

(1)OSWindows7,Vista,XP,2008(R2),2003̂ǂꂩłB
(2)Rs[^I1"܂"I2"łB(CXg[t@CȂꍇ)
(3).NET Framework 2.0ȏオCXg[ĂB(Vista,2008̓CXg[)
(4)MSSQL2008(R2),2005APostgreSQL9.0,8.4,8.3,IBM DB2 9.7,9.5,Oracle11G,10ĜǂꂩCXg[ĂB
(5)SQL@ServeȑꍇSQL SERVERF([hjLɂĂǂB
   tWINDOWSF؂͎gp܂ACXg[ŋۏo܂B
(6)ԋN̂߂̃XPW[T[rXJnĂǂB
(7)ShCũtH_["\I"ȉ𑼂̃\tgŎgpĂȂB
(8)T[rX"IVSRVC"𑼂̃\tgŎgpĂȂB
(9)L"I","VXe.I"𑼂̃\tgŎgpĂȂB
(10)TCP/IPݒ肳\Pbg̃|[gԍ"65432"gpĂȂB
@UDP/IPݒ肳\Pbg̃|[gԍ"65499"gpĂȂB
NCAggpꍇ̓t@CA[EI[𖳌ɂ邩
̃|[gOɐݒ艺B
(11)CXg[t@C"Rs[^.TXT"t@CCXg[tH_ɂ
 @@@   ܂"ZbgAbv_Rs[^.TXT"t@CB
   "I_I1.TXT"܂I_I2.TXThCXg[tH_ɂ܂B
(12)SQL Server͕WŃCXg[Ɖp͑啶,,Sp,p킸
   ƂĈ܂B
   mɋʂꍇ̓JX^ŕёւuoCivɐݒ肵
   SQL ServerCXg[ĉBi܂萄͏o܂j
(13)I̕ʃo[WCXg[ĂȂBi͂ł܂j
**************************************************************
3)gp_񏑂̓CXg[_ŕ\܂B
**************************************************************
4) ăCXg[ꍇ̒ӁB
(1)VXe񋟃vOđSčăCXg[܂B
   (%͈ȉSĂ̕Ӗ܂)
   (j[ZZZZ0101%,ZZZZ0102%,ZZZZ0103%,ZZZZ0104%,ZZZZ0105%,ZZZZ0107%,Z40%ł)
   (ԋNZZZZ99985%,ZZZZ99986%,ZZZZ99995%,ZZZZ99996%ł)
(2)̗グ͋NȂŉBi2dɋNĂ܂܂j
**************************************************************
5)CXg[@

CXg[\tgIōĂ܂A
]ĉʂ̑@I̕׋ɂȂ܂B
SETUP_JA.BATswɏ]đ쉺B
CXg[ȉ̓͂v܂B
==============================================================
(2-1)VXe
   1T[o[ɃVXe𕡐CXg[ł܂B
   8ȓŉp啶,,"_"(A_[C)̑gݍ킹łB
   pȊO擪ɂ鎖͏o܂B
(2-2)ZbgAbv
@@ł́hI"łB
(2-3)f[^x[X
(2-4)s
   \ꂽgpFl̂YES[Enter]ĉB
==============================================================
(3-1)CX^X
@@ʏ͋󔒂łCX^XzɎw肵Ăꍇ͓͉B
    iASQL ServerExpressEdition̏ꍇSQLEXPRESSftHglłBj
(3-2)VXe
@@fXNgbṽACR̕\ƂĎgp܂B
(3-3)Ǘ҃pX[h
   RDBMS̃CXg[Őݒ肵e܂B
(3-4)NpX[h
   NT[o[ppX[hłAQĉB
@@΂ɌJȂŉACXg[ύX͏o܂B
@@NT[o[ݒ莞̂ݒmĂKv܂B
    sɂu"vƁu'v͓͂ł܂B
(3-5)eXgpX[h
   eXgppX[hłAQĉB
@@΂ɌJȂŉACXg[ύX͏o܂B
@@vOJ҂AmȂĂAx͗L܂B
    sɂu"vƁu'v͓͂ł܂B
(3-6){ԃpX[h
   {ԃpX[hłAQĉB
@@΂ɌJȂŉACXg[ύX͏o܂B
@@mȂĂAI͗pł܂B
    sɂu"vƁu'v͓͂ł܂B
(3-7){DB{̃hCu
   {ԃf[^x[Xp̃hCułB
(3-8){DBOhCu<MSSQL>
   {ԃf[^x[XOp̃hCułB
   \ł(3-7)̃hCuƂ͕ʂ̑uɂĉB
(3-9){DBobNAbv<MSSQL>
   {ԃf[^x[XobNAbvp̃hCułB
   \ł(3-7)̃hCuƂ͕ʂ̑uɂĉB
(3-10)eXgDB{̃hCu
   eXgf[^x[X{̗phCułB
(3-11)eXgOhCu(f[^x[Xƕʑu)<MSSQL̂>
    eXgf[^x[XOphCułB
    \ł(3-10)̃hCuƂ͕ʂ̑uɂĉB
(3-12)eXgDBobNAbv<MSSQL̂>
   eXgf[^x[XobNAbvp̃hCułB
   \ł(3-10)̃hCuƂ͕ʂ̑uɂĉB
(3-13)administratorsSQLւ̃OC֎~<MSSQL̂>
    MSSQL̓ftHgłOSadministratorsMSSQLɂ
    Ǘ(sa)Ɠ^܂,̏Ԃ̓ZLeBȂ̂
    "YES"ŋ֎~ł܂B
@@,SQL@Serveȑꍇŋ֎~Enterprise Manager̓o^
    폜(YT[o[ŉE{^uSQL Server̓o^
    폜vuvŁuSQL Server̐VKo^vŁuVXeǗ҂蓖Ă
    SQL ServerOC(SQL Server F)vgēo^ĉB
    ,hNO"Ƃꍇ͉܂,ăCXg[gpB
(3-14)BL(ADMIN$,C$)r
      ZLeBmۂ̂߉BL(ADMIN$,C$)r܂"YES"Ŕr
      ۂɂ̓WXg[HKEY_LOCAL_MACHINE2ݒ肵܂
      Key="\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters"
      DataType=REG_DWORD,Value="AutoShareServer"y"AutoShareWks"
      Data=0X00000000
      ,hNO"Ƃꍇ͉܂,ăCXg[gpB
     (ꍇ͊Y̒l2"regedt32"ō폜܂)
(3-15)Guest ̉{
     ǂ̃NCAgڑ\ɂ邽߁uGuest̖v܂
     "YES"ŉBBLr̂ŃZLeB̖͉ł܂B
     (NCAg̐ڑOS̔F؂g܂)
      ,"NO"Ƃꍇ͉܂,ăCXg[gpB
(3-16)̓f[^̍ĕ\YESŃCXg[Jn܂B
==============================================================
(4-1)YESŎwɏ]ĊǗ҃pX[hQݒ肵ĂB
@@ӁFŐݒ肵ĂȂƍŏ̔F؂ŃpX[hύXv܂B
 ==============================================================
(5-1)YESŎwɏ]č݃e[uXVĉB
==============================================================
(6-1)YESŎwɏ]ăJ_[ՓXVĉB
(6-2)YESŒ̗グsĉB
J_[̎̉ғŗグ̎s\񂪐ݒ肳܂B
Yx̏ꍇ̓J_[CƋN\̕ύXKvɂȂ܂B
(6-3)LQӏEVERYONẼANZXEC[XɊȂ悤
@@@ύXB
(6-4)"YES"Ĩj[\ăCXg[łB
j[\88Ɠ͂ăwvǂ݉B
==============================================================
VjiQljopenSUSȄꍇsmbgp̂Ńt@C[EH[ŋKv܂B
[Start]|[Configer Desktop]-[Advanced]-[YaST]-[Network Services]-[Samb Server]
[Start-Up][Open Port in Firewall]Ƀ`FbNĉB




񋟎ҁFM

ȏB
