Insight Installer

InsightInstaller.exe Command-Line Tool

In the packages\tools folder, you will find InsightInstaller.exe. This command-line tool will allow you to use the Insight schema installation engine without adding the code to your setup program. It's also quite handy for testing schema installs.

Usage: InsightInstaller [options] [filespec1 filespec2...]

Examples:

InsightInstaller -s proddb -db mydatabase *.sql

Parameters:

Filespec can use wildcards. It can be .SQL files or assembly files with embedded resources (.dll or .exe).

Options:

-help               : shows this help

-c connectionstring : sets the connection string (or use -s -db -u -p)
-s server           : sets the server (if -c not specified)
-db database        : sets the database (if -c not specified)
-u userid           : sets the username (default is integrated security)
-p password         : sets the password (default is integrated security)

-g schemagroup      : sets the schema group to install under (default is ")
-r                  : enables repair mode
-v                  : enables verbose errors

-uninstall          : allows uninstall of an empty schema