How do I add/update a property inside an MSI from the command-line?

by

Example VBScript that you could use to update (or add) a property post-build… 

    Option Explicit

    Const MSI_FILE = "myfile.msi"


    Dim installer, database, view

    Set installer = CreateObject("WindowsInstaller.Installer")
    Set database = installer.OpenDatabase (MSI_FILE, 1)

    ' Update
    Set view = database.OpenView ("UPDATE Property SET Value="" & myproperty & "" WHERE Property = 'MYPROPERTY'")

    ' .. or Add (Insert)
    Set view = database.OpenView ("INSERT INTO Property (Property, Value) VALUES ('MYPROPERTY', '" & myproperty & "')")
    view.Execute
    database.Commit

    Set database = Nothing
    Set installer = Nothing
    Set view = Nothing

For more information check out the Windows Installer SDK (part of the Windows SDK)

There’s a bunch of example scripts that you can use from the command line to do various MSI manipulation tasks

For example WiRunSQL.vbs lets you execute arbitrary SQL against an MSI.

More Related Contents:

  1. WIX Installer with modern look and feel
  2. How to avoid the “Windows Defender SmartScreen prevented an unrecognized app from starting warning”
  3. Uninstall and Install App on my Computer silently
  4. How can you find and replace text in a file using the Windows command-line environment?
  5. How do I get the application exit code from a Windows command line?
  6. How to check if a process is running via a batch script
  7. Redirect Windows cmd stdout and stderr to a single file
  8. How to echo with different colors in the Windows command line [closed]
  9. Maximum Length of Command Line String
  10. Node.js/Windows error: ENOENT, stat ‘C:\Users\RT\AppData\Roaming\npm’
  11. How to create a simple install system for VB6 on XP/Vista and newer? [closed]
  12. How can I create an empty file at the command line in Windows?
  13. Create an empty file on the commandline in windows (like the linux touch command)
  14. Is there replacement for cat on Windows
  15. Is there a better Windows Console Window? [closed]
  16. How to prevent auto-closing of console after the execution of batch file
  17. Windows equivalent of the ‘tail’ command [duplicate]
  18. How do I shutdown, restart, or log off Windows via a bat file?
  19. How to I launch a ruby script from the command line by just its name?
  20. Concatenate text files with Windows command line, dropping leading lines
  21. Cannot run Maven using `mvn -D` argument within Microsoft Powershell, but works in Command Prompt
  22. batch file to check 64bit or 32bit OS
  23. How to create a robust, minimal installer for Windows? [closed]
  24. How do I get the equivalent of dirname() in a batch file?
  25. Running R Code from Command Line (Windows)
  26. How to start jenkins on different port rather than 8080 using command prompt in Windows?
  27. Difference between %variable% and !variable! in batch file
  28. How to prevent that java.exe is installed in Windows’ system32?
  29. Run batch file in Windows Installer Commit
  30. Start/Stop and Restart Jenkins service on Windows

Leave a Comment