MAKEMSI quickly and reliably creates MSI files in a non-programmatic way\Tips and TricksToolsMSI (Windows Installer) Platform SDKSDK PROGRAM FILES - SUNDRYSDK: MsiDb.Exe (C:\Program Files\Microsoft Platform SDK\Bin\)

---

SDK: MsiDb.Exe (C:\Program Files\Microsoft Platform SDK\Bin\)

This is an MSI related SDK EXE file (matched "msi*.exe) installed via the "Platform SDK" (click to see a list of others).

If the mode, folder, database and table list are specified on the
command line, Msidb.exe does not bring up any user interface and
operates as a silent command-line utility suitable for build script.

Syntax
~~~~~~
MsiDb {option}...{option}... {table}...{table}

-i Import text archive files from folder into database. Table names
   for import are file names 8 characters long with an ".idt"
   extension. Longer names are truncated to 8 characters if supplied by
   command for import. Standard wild card specifications may be used.

-e Export selected tables from database into text archive files in
   folder. Table names for export are table names. Only the wildcard
   specification, "*", may be used. Tables may be exported from a read
   only database.

-c Creates a new database file and imports tables. Overwrites an
   existing database file.

-f Specifies the folder containing the text archive files for tables
   and streams. If the folder containing the text archive files is not
   specified, the utility prompts the user for the folder.

-d Fully-qualified path to the database file.

-m Fully-qualified path to the database that is to be merged in. This
   option is available only in silent command line mode. Multiple
   instances of this option may occur to a maximum of 10. If the
   database is not specified on the command-line, the utility prompts
   the user for the database.

-t Fully-qualified path to the transform to be applied. This option
   is available only in silent command line mode. Multiple instances of
   this option may occur to a maximum of 10.

-j Name of storage to remove from the database. This option is
   available only in silent command line mode. Multiple instances of
   this option may occur to a maximum of 10.

-k Name of stream to remove from the database. This option available
   only in silent command line mode. Multiple instances of this option
   may occur to a maximum of 10.

-x Name of stream to save to a disk file in the current directory.
   This option is available only in silent command line mode. Binary
   data streams are stored as separate files with the extension ".ibd".
   Binary filename used is primary key data for the row containing the
   stream.

-w Name of storage to save to a disk file in the current directory.
   This option is available only in silent command line mode.

-a Name of file to add to the database as a stream. This option is
   available only in silent command line mode. Multiple instances of
   this option may occur to a maximum of 10. Binary data streams are
   stored as separate files with the extension ".ibd". Binary filename
   used is primary key data for the row containing the stream.

-r Name of storage to add to the database as a substorage. This
   option available only in silent command line mode. Multiple
   instances of this option may occur to a maximum of 10.

-s Truncate table names to 8 characters on export to an .idt. The
   table name is truncated to 8 characters and the extension ".idt" is
           added.

Please email me any feedback, additional information or corrections. See this page online (look for updates) MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved). Saturday November 15 2008 at 2:05pm Visit MAKEMSI's Home Page