Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » Database and application deployment

 

Silent installs using the SQL Anywhere installer

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 common 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 window. Use this option 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 pkg\SQLAnywhere directory on the disk in drive d:.

d:\pkg\sqlanywhere\setup.exe /l:1033 /s "/v: /qn 
    REGKEY=QEDEV-B888A-6L123-45678-90123 INSTALLDIR=c:\sa16 DIR_SAMPLES=c:\sa16\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.

Caution should be exercised with the use of the MSIEXEC /qn option since the computer system may shut down and restart without warning.

The following properties apply to the SQL Anywhere installer:

  • 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.

  • DIR_SQLANY_MONITOR   The value of this parameter is the path to where the SQL Anywhere Monitor database (samonitor.db) is 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\").

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

  • REGKEY_ADD_1   The value of this parameter must be a valid software registration key for an add-on feature such as FIPS encryption. This property applies only if you have optional add-on features to be installed during this run of the installer.

  • REGKEY_ADD_2   The value of this parameter must be a valid software registration key for an add-on feature such as FIPS encryption. This property applies only if you have optional add-on features to be installed during this run of the installer.

  • REGKEY_ADD_3   The value of this parameter must be a valid software registration key for an add-on feature such as FIPS encryption. This property applies only if you have optional add-on features to be installed during this run of the installer.

The following example shows how to specify the SQL Anywhere install properties:

d:\pkg\sqlanywhere\setup.exe /S "/v: /qn 
USERNAME=\"John Smith\" 
COMPANYNAME=\"Smith Holdings\" 
REGKEY=QEDEV-B888A-6L123-45678-90123 
REGKEY_ADD_1=<an add-on software registration key> 
REGKEY_ADD_2=<another add-on software registration key> 
INSTALLDIR=c:\sa16 
DIR_SAMPLES=c:\sa16\Samples 
DIR_SQLANY_MONITOR=c:\sa16\Monitor"

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.

The following properties apply to the SQL Anywhere Monitor installer (located in d:\pkg\Monitor\setup.exe):

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

  • DIR_SQLANY_MONITOR   The value of this parameter is the path to where the SQL Anywhere Monitor database (samonitor.db) is installed.

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

  • REGKEY_ADD_1   The value of this parameter must be a valid software installation key for an add-on feature such as FIPS encryption. This property applies only if you have optional add-on features to be installed during this run of the installer.

  • REGKEY_ADD_2   The value of this parameter must be a valid software installation key for an add-on feature such as FIPS encryption. This property applies only if you have optional add-on features to be installed during this run of the installer.

The following example shows how to specify the SQL Anywhere Monitor install properties:

d:\software\monitor\setup.exe /S "/v: /qn 
REGKEY=<SQLAnywhere Monitor registration key> 
REGKEY_ADD_1=<an add-on software registration key> 
REGKEY_ADD_2=<another add-on software registration key> 
INSTALLDIR=c:\sa16"

In addition to setting the property values described above, the following SQL Anywhere components or features may be selected from the command-line:

Feature Property x86 Default x64 Default
Administration Tools (32-bit) AT32 1 0
Administration Tools (64-bit) AT64 0 1
CAC Authentication CAC *
FIPS-certified Encryption FIPS *
High Availability HA *
In-Memory Mode IM *
MobiLink (32-bit) ML32 1 0
MobiLink (64-bit) ML64 0 1
Read-only scale-out SON *
Relay Server (32-bit) RS32 1 0
Relay Server (64-bit) RS64 0 1
Samples SAMPLES 1 1
SQL Anywhere (32-bit) SA32 1 0
SQL Anywhere (64-bit) SA64 0 1
SQL Anywhere for Windows Mobile MOBILE 1 1
SQL Anywhere Monitor (32-bit) SM32 1 0
SQL Anywhere Monitor (64-bit) SM64 0 1
SQL Remote (32-bit) SR32 1 0
SQL Remote (64-bit) SR64 0 1
UltraLite UL 1 1

* These features require an additional appropriate software registration key.

Set the property value to 1 to select the feature or to 0 to omit the feature. For example, to omit 32-bit MobiLink, set ML32=0. To select the 32-bit Administration Tools, set AT32=1. These properties are used to override the default selection.

You don't need to specify the selection state of a feature if the default is applicable. For example, to override the default selection on a 64-bit computer by installing the 32-bit MobiLink feature and not installing the Samples, use the following command line:

setup.exe "/v ml32=1 samples=0"

Property names are case insensitive.

Your registration key may limit the available features. The command-line options cannot be used to override those limitations. For example, if your registration key does not allow the install of FIPS Encryption, then using FIPS=1 on the command-line will not select the feature.

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

/l*v! logfile

In this example, logfile is the full path and file name of the log file. The path must already exist. This option generates an extremely verbose log and significantly lengthens the time required to execute the install. For information about reducing the output to the log file, see [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 {3D7AB509-4FC2-4570-9913-A8F1CAD8C743} /l*v %temp%\sauninstall.log

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.

  • /l*v %temp%\sauninstall.log   This parameter tells the Microsoft Windows Installer to create a log file in the specified location.

The product codes for SQL Anywhere version 16.0 are:

  • {3D7AB509-4FC2-4570-9913-A8F1CAD8C743}   SQL Anywhere software

  • {37B83CDB-F75E-4428-A9C2-995D92105EEC}   SQL Anywhere client-only software

  • {1AF08ED0-804C-4AFF-BB6C-D980D81AD594}   SQL Anywhere Monitor