SQLDMO Installer

Author: jilchev (talk, contrib)

Description

I was looking for a standalone solution to deploy SQLDMO and after I couldn't find such in the NSIS Wiki or elsewhere on the web I decided to do it! Based on info available on the web: http://support.microsoft.com/Default.aspx?kbid=326613 and similar merge module by Anthony Glenwright.

The Script

Here is what came at the end (comments are welcome): Note: There was an uninstall issue in version 1.0 of this script! Thanks Zdravko!

; SQLDMO Installer
; English Language version
; by Jordan Ilchev (Tangra Inc.)
; based on Microsoft KB#326613 & similar Anthony Glenwright's Merge Module (MSI/MSM)
 
; HM NIS Edit Wizard helper defines
!define PRODUCT_NAME "SQLDMO Installer"
!define PRODUCT_VERSION "1.1"
!define PRODUCT_PUBLISHER "Jordan Ilchev"
!define PRODUCT_WEB_SITE "http://support.microsoft.com/Default.aspx?kbid=326613"
!define PRODUCT_UNINST_KEY "Software\Microsoft\Windows\CurrentVersion\Uninstall\${PRODUCT_NAME}"
!define PRODUCT_UNINST_ROOT_KEY "HKLM"
 
SetCompressor lzma
 
; MUI 1.67 compatible ------
!include "MUI.nsh"
 
; MUI Settings
!define MUI_ABORTWARNING
!define MUI_ICON "${NSISDIR}\Contrib\Graphics\Icons\modern-install.ico"
!define MUI_UNICON "${NSISDIR}\Contrib\Graphics\Icons\modern-uninstall.ico"
 
; Welcome page
!insertmacro MUI_PAGE_WELCOME
; Instfiles page
!insertmacro MUI_PAGE_INSTFILES
; Finish page
!insertmacro MUI_PAGE_FINISH
 
; Uninstaller pages
!insertmacro MUI_UNPAGE_INSTFILES
 
; Language files
!insertmacro MUI_LANGUAGE "English"
 
; Reserve files
!insertmacro MUI_RESERVEFILE_INSTALLOPTIONS
 
; MUI end ------
 
Name "${PRODUCT_NAME} ${PRODUCT_VERSION}"
OutFile "SQLDMO-Setup.exe"
InstallDir "$PROGRAMFILES\Microsoft SQL Server\80\Tools\Binn"
ShowInstDetails show
ShowUnInstDetails show
 
Section "MainSection" SEC01
 
  ; Check if SQL DM is registered on target system
  ReadRegStr $0 HKCR CLSID\{10020100-E260-11CF-AE68-00AA004A34D5}\VersionIndependentProgID ""
  StrCmp $0 "" install_go 0
    DetailPrint "Key Value: $0"
    DetailPrint "SQLDMO already installed!"
    DetailPrint "Setup is terminating the installation process."
    MessageBox MB_OK "SQLDMO already installed!$\nSetup is terminating the installation process."
    Quit
 
  install_go:
  ClearErrors
 
  SetOutPath "$INSTDIR"
  SetOverwrite ifnewer
  File "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlsvc.DLL"
  File "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlresld.DLL"
  File "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.dll"
  File "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\w95scm.DLL"
  SetOutPath "$INSTDIR\Resources\1033"
  File "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.rll"
  File "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SQLDMO.RLL"
  SetOutPath "$SYSDIR"
  File "C:\WINDOWS\system32\sqlwid.dll"
  File "C:\WINDOWS\system32\sqlwoa.dll"
 
  ;Register SQLDMO.DLL
  ExecWait 'regsvr32.exe /s "$INSTDIR\SQLDMO.dll"'
 
SectionEnd
 
Section -Post
  WriteUninstaller "$INSTDIR\uninst.exe"
  WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "DisplayName" "$(^Name)"
  WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "UninstallString" "$INSTDIR\uninst.exe"
  WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "DisplayVersion" "${PRODUCT_VERSION}"
  WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "URLInfoAbout" "${PRODUCT_WEB_SITE}"
  WriteRegStr ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}" "Publisher" "${PRODUCT_PUBLISHER}"
SectionEnd
 
 
Function un.onUninstSuccess
  HideWindow
  MessageBox MB_ICONINFORMATION|MB_OK "$(^Name) was successfully removed from your computer."
FunctionEnd
 
Function un.onInit
  MessageBox MB_ICONQUESTION|MB_YESNO|MB_DEFBUTTON2 "Are you sure you want to completely remove $(^Name) and all of its components?" IDYES +2
  Abort
FunctionEnd
 
Section Uninstall
 
  ;UnRegister SQLDMO.DLL
  ExecWait 'regsvr32.exe /s /u "$INSTDIR\SQLDMO.dll"'
 
  Delete "$INSTDIR\uninst.exe"
  Delete "$SYSDIR\sqlwoa.dll"
  Delete "$SYSDIR\sqlwid.dll"
  Delete "$INSTDIR\Resources\1033\SQLDMO.RLL"
  Delete "$INSTDIR\Resources\1033\sqlsvc.rll"
  Delete "$INSTDIR\w95scm.DLL"
  Delete "$INSTDIR\SQLDMO.dll"
  Delete "$INSTDIR\sqlresld.DLL"
  Delete "$INSTDIR\sqlsvc.DLL"
 
  RMDir "$INSTDIR\Resources\1033"
  RMDir "$INSTDIR"
 
  DeleteRegKey ${PRODUCT_UNINST_ROOT_KEY} "${PRODUCT_UNINST_KEY}"
  SetAutoClose true
SectionEnd

Enjoy! J.