Run package from CLI silent mode
maukeman
Posts: 4
I would like to run a SQL package with command line statement from an installer script (Ghost Installer) with no manual intervention from the user. The SQL Server instance name and the database name are pre-determined and should not be changeable by the user when they run the installer. Can this be done with Packager??
Comments
Absolutely yes! A package can be run in command line mode, with switches to make a database with a certain name:
package.exe /server:localhost /database:mydatabase /makedatabase /quiet
Any Windows Installer authoring tool should allow you to create a custom action and pass the arguments through to Packager. This means that you could hard-code the server and database name, or you could have a form in the installer package to allow the user to set the server and database name.