Using a silent install for deployment

Silent installs run without user input and with no indication to the user that an install is occurring. On Windows operating systems, you can call the SQL Anywhere installer from your own install program in such a way that the SQL Anywhere install is silent.

The options for the SQL Anywhere install program setup.exe are:

  • /L:language_id   The language identifier is a locale number that represents the language for the install. For example, locale ID 1033 identifies U.S. English, locale ID 1031 identifies German, locale ID 1036 identifies French, locale ID 1041 identifies Japanese, and locale ID 2052 identifies Simplified Chinese.

  • /S   This option hides the initialization dialogue. Use this option in conjunction with /V.

  • /V   Specify parameters to MSIEXEC, the Microsoft Windows Installer tool.

The following command line example assumes that the install image directory is in the software\SQLAnywhere directory on the disk in drive d:.

d:\software\sqlanywhere\setup.exe /l:1033 /s "/v:/qn 
    REGKEY=PEPEV-E96QE-A4000-00000-00000 INSTALLDIR=c:\sa11 DIR_SAMPLES=c:\sa11\Samples"
Note

The setup.exe in the command above is the one located in the same directory as the SQLANY32.msi and SQLANY64.msi files. The setup.exe in the parent directory of those files does NOT support silent installs.

The following options may be specified on the command line.

  • REGKEY   The value of this parameter must be a valid software installation key.

  • INSTALLDIR   The value of this parameter is the path to where the software is installed.

  • DIR_SAMPLES   The value of this parameter is the path to where the sample programs are installed.

  • USERNAME   The value of this parameter is the user name to record for this installation (for example, USERNAME=\"John Smith\").

  • COMPANYNAME   The value of this parameter is the company name to record for this installation (for example, COMPANYNAME=\"Smith Holdings\").

The following example includes all the options:

d:\software\sqlanywhere\setup.exe /l:1033 /s "/v:/qn 
    REGKEY=PEPEV-E96QE-A4000-00000-00000 
    INSTALLDIR=c:\sa11 
    DIR_SAMPLES=c:\sa11\Samples
    USERNAME=\"John Smith\"
    COMPANYNAME=\"Smith Holdings\""

Although the above text is shown over several lines for reasons of length, it would be specified as a single line of text. Note the use of the backslash character to escape the interior quotation marks.

You can also install the documentation using a silent install. The setup.exe for this is in d:\software\Documentation. An example of a command line that installs the documentation is:

d:\software\documentation\setup.exe /l:1033 /s "/v:/qn"

To generate an MSI log add the following to the command line after the /v:.

/l*v! logfile

In the above example, logfile is the full path and file name of the log file. The path must already exist. Note that this switch will generate an extremely verbose log and will significantly lengthen the time required to execute the install. See the MSI documentation for details on how to reduce the output to the log file ([external link] http://msdn.microsoft.com/en-us/library/aa367988.aspx).

In addition to a silent install, it is also possible to perform a silent uninstall. The following is an example of a command line that would do this.

msiexec.exe /qn /uninstall {ECE263B0-6C8B-404C-B4AC-8FAB1C87AB4A}

In the above example, you call the Microsoft Windows Installer tool directly.

  • /qn   This parameter tells the Microsoft Windows Installer to operate in the background with no user interaction.

  • /uninstall <product-code>    This parameter tells the Microsoft Windows Installer to uninstall the product associated with the specified product code. The code shown above is for the SQL Anywhere software.

The product codes for SQL Anywhere are:

  • {ECE263B0-6C8B-404C-B4AC-8FAB1C87AB4A}   SQL Anywhere software

  • {10964A7D-722B-4FE5-A16D-4977DCECEE95}    SQL Anywhere documentation

The silent install described above does not address how you would select a subset of the components to install. This topic is better addressed by the Deployment Wizard. For information on component selection, see Using the Deployment Wizard.