Run package from CLI silent mode

maukemanmaukeman Posts: 4
edited July 7, 2006 2:43PM in SQL Packager Previous Versions
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??
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    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.
    · Share on Twitter
Sign In or Register to comment.