Msidb.exe

Msidb.exe uses MsiDatabaseImport and MsiDatabaseExport to import and export database tables and streams.

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}

Command Line Options

Msidb.exe uses the following case-insensitive command line options. A slash delimiter may also be used in place of a dash.

OptionDescription
-iImport 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.
-eExport 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.
-cCreates a new database file and imports tables. Overwrites an existing database file.
-fSpecifies 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.
-dFully qualified path to the database file.
-mFully 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.
-tFully 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.
-jName 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.
-kName 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.
-xName 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.
-wName of storage to save to a disk file in the current directory. This option is available only in silent command line mode.
-aName 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.
-rName 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.
-sTruncate table names to 8 characters on export to an .idt. The table name is truncated to 8 characters and the extension ".idt" is added.
-?Displays the command line help dialog

 

Note  When using long filenames with spaces, use quotes around them. For example, for a database that is in the "My Documents" folder, specify it as "c:\my documents".

This tool is only available in the Windows SDK Components for Windows Installer Developers.

Related topics

Windows Installer Development Tools
Released Versions, Tools, and Redistributables

 

 

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.