????? ????? ????? ??????? ???? Sample.msi MSDE 2000

???? ??? ??????? ????? ????? ??? ????? ?? Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) ?????? Sample.msi. ?? Sample.msi ???? ????? ??????? ?? ????? ????? ?? SQL Server ????? ? SQL Server ??????? ? ??????? ?????? SQL Server.

??????? ????

????? ??????? ??? Sample.msi ??? ???? MSDE 2000 ?? ??????? ????? ??. ???????? ????? Sample.msi ????? ????? ??? ?????? "?" ??? ?????? ??? ???? ???? ????? ?? ?????? ?? ???????? ?????? ???? ?? ??????? ??? ????????? ????. ????? ?? ?????????? ???? ??????? "????? Desktop Engine ????? ???? ?????" ?? SQL Server 2000 ????????.

?????? ????? ??????? MSDE 2000 ??? ?? ???? ???? ??? ???? ?? ?????? Windows Installer. ????? ?? ????????? ??? ?????? Windows Installer ?????? ????? ???? Microsoft ?????? ??? ????? ???? ????? SDK ???? Windows:

??? ?? ???? ???? SDK ??????? Windows Installer ??????? 1.5 ?? 2.0 ????? ???? ??????? ????? ??????? ?? ??? ???????. Windows Installer 2.0 SDK ??? ????? ???? ?? Windows Platform SDK. ???????? ??? ???? ???? ?? ???? ?????? ??????? ??????? ???????:

• Orca.exe
• Guidgen.exe
• Msimsp.exe
• Makecab.exe
• Patchwiz.dll

??? ?? ???? ??????? ??? ???? Orca.exe ?????? ??????? ???????? ? ????? ??? ?????? ?????? ??? ?????? ?????? ? ?????? ???? ????? ????? ???????? ???? ??? .msi.

?????? ??? ??????? ?????? ??? ????? ??????? Orca.exe ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:

??????? ??????? ?????? ????? ???? ??????

??? ??????? ??????? ????? ????? ????? ????? ??? ???? ?????? Service Pack 1 "?????? ??? ??????? 2000 MSDE ??? Sample.msi" ?????? ???????? "(RTM).

??????: ????? ???? ??????? Service Pack 1 ?? Service Pack 2.

1. ????? ???????? ?? ?? ???? ???????:
   1. ?????? ??? ??????? ??? ?????? ???? ???? \\MachineA\Share1. ????? ??????? ????? ???????, ??? ???? ??????? ???? ?????? ???????? ??? ?????? ????????? ????? ?? ?????. ????? ???? ?????? ???? ?????? ??????? ??????? ?? ???? ?????? ?????? ?????? ??? ???? ????????? ????? ????? ???????:
      
      
      \\MachineA\Share1\RTM
      \\MachineA\Share1\RTM\AdminImage
      \\MachineA\Share1\Sp1
      \\MachineA\Share1\Sp1\AdminImage
      \\MachineA\Share1\RTM\Patch
      
      
      
      ??????: ???? ?? ???? ???????? ???????. ???????? ??? ???? ????? ??????? ????? ????? (UNC) ??? ????? ??? ??????? ??? ??? ?????? ?? ????? ??????? ??????.
   2. ??? ????? Sample.msi ? Sqlrun.cab ?? MSDE 2000 RTM ??? ?????? \\MachineA\Share1\RTM. ??? ??? ?????? ?????? ????? Sample.msi (?? ???? ????? ??? ?????? ?? ??? ?????? ?? ??? Sample.msi) ??? ??? Sample.msi ??.
      
      ??????: ???? ??? Sample.msi ?? Devtools\Samples\Desktop ?????? ?????? Sqlrun.cab ??????? ?? ?????? MSDE\Setup.
   3. ??? ????? Sqlrun01.msi ? Sqlrun.cab ?? MSDE 2000 Service Pack 1 ??? ???? \\MachineA\Share1\Sp1.
      
      ??????: Sqlrun01.msi ????? ?????? SP1 ?? ??????? ??????? ??? ?? ??? Sqlrun01.msi ? SP2 ??????? ??????? ???? ?? ??????? ??? ????????? ??????? MSDN.
2. ????? ?? ???? ?? ?????? ???? ?????? ?? ??? Sqlrun01.msi.
   1. 
      
      ??????: ??? ????? ???? ???? ????? (GUID) ? ???? ?? ?????? ??? ???? ?????? ???????. ????? ??? ??? ???? GUIDs ???????? ?? ??? ???????. ???? ????? ???? ???? ????????? SDK ??????? Windows Installer ?? ?????? ???? ???? ??? ?? ???? GUID. ??? ?????? ???????? Guidgen.exe ?????? GUID ???? ????? ??? ???? ????? ? ??? ????? ???? ????? ?? ??? GUID ??? ???? ????? ??? ????????? ??? ?????? ?? ??? ??????.
      
      
   2. ????? ??? ?????? ?? ?????? ????? Sqlrun01.msi ??????? ??? ?????? ?? ??? Sample.msi.
   3. ??????? ???? Guidgen.exe ????? GUID ????. ???? ?? ?? GUID ???? ?? ???? ?????. ?? ????????? ????????? ?? Sqlrun01.msi ????? ??? ?????? ??? GUID ???? ???????? Orca.exe ?? ?????? "??" ???? Msiinfo.exe.
3. ????? ??? Windows Installer ????????:
   1. 
      
      
   2. ????? ???? ????? ???? Sample.msi ???????? ??? ?????? ??? ???:

      msiexec.exe /a \\MachineA\Share1\RTM\Sample.msi TARGETDIR=\\MachineA\Share1\RTM\AdminImage /L*v \\MachineA\Share1\RTM\AdminImage\Admin.log

   3. ????? ???? ????? Sqlrun01.msi ??? ???????? ??? ?????? ??? ???:

      msiexec.exe /a \\MachineA\Share1\sp1\Sqlrun01.msi TARGETDIR=\\MachineA\Share1\Sp1\AdminImage /L*v \\MachineA\Share1\Sp1\AdminImage\Admin.log

   4. ??????? ???? Orca.exe ?? ???? Msiinfo.exe ????? ?? ?? ?? ???? ?????? ????? .msi ????? ?? ?????? ?????? AdminImage.
4. ??? ????? ????? ????? ???????:
   1. 
      
      
   2. ??? ??? Template.pcp ?? SDK ??????? Windows Installer ??? \\MachineA\Share1\Patch ?? ?? ?????? ???? Orca.exe ????? ????????? ??????? ?? ??????? ?? ??????? ??????? ??? ???????:
      1. ????? ?? ?? ???? ImageFamilies ???? ????? ??? ????? ???????:
         ?? ??? ??????????? ??? ??????

         ????	????
         ???????	MSDEApps
         MediaSrcPropName	msde_sp1_update
         MediaDiskId	2
         FileSequenceStart	1000

      2. ????? ?? ?? ???? UpgradedImages ???? ????? ??? ????? ???????:
         ?? ??? ??????????? ??? ??????

         ????	????
         ?????	MSDE_sp1
         MsiPath	\\MachineA\Share1\Sp1\AdminImage\Sqlrun01.msi
         ???????	MSDEApps

         
         
      3. ????? ?? ?? ???? TargetImages ???? ????? ??? ????? ???????:
         ?? ??? ??????????? ??? ??????

         ????	????
         ?????	MSDE_rtm
         MsiPath	\\MachineA\Share1\RTM\AdminImage\Sample.msi
         ?????	MSDE_sp1
         ?????	1
         ProductValidateFlags	0x00000922
         IgnoreMissingSrcFiles	0

         
         
         
      4. ????? ?????? ?? ???? ????? ??? ????? ???????:
         ?? ??? ??????????? ??? ??????

         ????	????
         PatchOutPutpath	\\MachineA\Share1\Patch
         PatchGUID	??????? GUID ???? ?? ?????? ?????? Guiden.exe. (???? ?? ?? GUID ?? ???? ?????.)
         AllowProducctCodeMismatches	0
         AllowProductVersionMajorMismatches	0
         IncludeWholeFilesOnly	1

      5. ????? ??? ?????? ??? Template.pcp ??? GUID ???? ?? ?????? ?????? Guidgen.exe. ???? ?? ?? GUID ????? ?????.
      6. ????? ????? ????? Template.pcp Msde.pcp.
   3. ????? ??? ??????? ???????? ???? Msimsp.exe. ????? ??????? ??? ?????? ????? ??????? ??????:
      

      msimsp.exe -s \\MachineA\Share1\Patch\msde.pcp -p \\MachineA\Share1\Patch\Sample.msp -l \\MachineA\Share1\Patch\log.txt -f \\MachineA\Share1\Patch\tmp

      ?????? ?? ??? ??? Log.txt ?????? ?? ???? ?? ??? ??? ????? ???? Msimsp.exe ???????. ??? ??? ?????? Msimsp.exe ????? ?????? ???????, ??? ???? Sample.msp ?? ?????? \\MachineA\Share1\Patch.
   4. ?????? ??? ???????. ??? ????? ??????? ??? ??????? ???? Sample.msi ??????? ???????? ????? ??????? ??????:
      

      Msiexec.exe /p Sample.msp REINSTALL=ALL REINSTALLMODE=omus /L*v SamplePatch.txt

      
      ?????? ?? ??? ??? SamplePatch.txt ?????? ?? ???? ????? ???????.
      
      ??????: REINSTALL = ALL ???? ?????? ????? ??? ??? ??????? ???? ?? ??????? ?????? ??????. ???????? ??? ???? ??? ??? ?????? ??????? REINSTALL ??? ????? ??????? REINSTALLMODE ??????? ??? ????? ?? ????? ????? ????? ??????.
      
      ?? ??? ??????????? ??? ??????

      reinstallmode	???
      o	????? ????? ??? ??? ????? ??????? ?? ?? ???? ???? ????? ????.
      m	????? ????? ???? ??????? ??????? ???????? ?? ???? ??????? ???????? ??? ???? ??????? HKEY_CLASSES_ROOT "??" KEY_LOCAL_MACHINE. ????? ????? ???? ????????? ?? ??? ???? ??? ?????? ? PublishComponent ??????, ProgID ?????? ? MIME ?????? ? ??? ?????? ? ?????? ???? ? ???? ???? ??????? ??? ????? ?? ????? ?????? ?? ????????. ????? ????? ???? ???????? ???????.
      u	????? ????? ???? ??????? ??????? ???????? ?? ???? ??????? ???????? ??? ???? ??????? HKEY_CURRENT_USER ?? HKEY_USERS.
      s	????? ????? ???? ?????????? ?????? ????? ??????? ?????? ???? ?????? ??????? ??? ?? ?????????? ???????? ???????.