The SQL Anywhere Deployment Wizard is the preferred tool for creating 32-bit deployments of SQL Anywhere for Windows. The Deployment Wizard can create installer files that include some or all the following components:
Client interfaces such as ODBC
SQL Anywhere server, including remote data access, database tools, and encryption
UltraLite relational database
MobiLink server, client, and encryption
QAnywhere messaging
Administration tools such as Interactive SQL and Sybase Central
The Deployment Wizard does not include support for creating deployments of the 64-bit software components.
You can use the Deployment Wizard to create a Microsoft Windows Installer Package file or a Microsoft Windows Installer Merge Module file:
Microsoft Windows Installer Package file A storage file containing the instructions and data required to install an application. An Installer Package file has the extension .msi.
Microsoft Windows Installer Merge Module file A simplified type of Microsoft Installer Package file that includes all files, resources, registry entries, and setup logic to install a shared component. A merge module has the extension .msm.
A merge module cannot be installed alone because it lacks some vital database tables that are present in an installer package file. Merge modules also contain additional tables that are unique to themselves. To install the information delivered by a merge module with an application, the module must first be merged into the application's Installer Package (.msi) file. A merge module consists of the following parts:
A merge module database containing the installation properties and setup logic being delivered by the merge module.
A merge module Summary Information Stream describing the module.
Redistribution of files is subject to your license agreement. You must acknowledge that you are properly licensed to redistribute SQL Anywhere files. Check your license agreement before proceeding.
Start the Deployment Wizard:
From the Start menu, choose Programs » SQL Anywhere 11 » Deploy SQL Anywhere For Windows.
or
From the Deployment subdirectory of your SQL Anywhere installation, run DeploymentWizard.exe.
Follow the instructions in the wizard.
The Deployment Wizard allows you to select subsets of the components included in SQL Anywhere. Each component has dependencies on other components so the files that are selected by the wizard may include files from other categories.
In Select Features, the available categories are Databases, Synchronization, and Administration Tools.
Use to select or deselect all of its subcategories.
SQL Anywhere (32-bit) Use to select or deselect all of its subcategories.
The following subcategories are available:
Client Interface Use to select or deselect all of its subcategories.
ODBC The SQL Anywhere ODBC driver.
Embedded SQL The SQL Anywhere Embedded SQL library.
OLEDB The SQL Anywhere OLE DB provider.
ADO.NET The SQL Anywhere .NET provider.
JDBC The SQL Anywhere JDBC driver.
Client Tools The SQL Anywhere client libraries like dblib11, dbtool11 and client utilities like dblocate, dbping, dbisqlc, and dbdsn.
Client Resources The SQL Anywhere language resource files like dblgen11, dblgde11, and dblges11 and the dblang language selection tool.
SQL Anywhere Server Use to select or deselect all of its subcategories.
Personal Server The SQL Anywhere personal server and license file.
Network Server The SQL Anywhere network server and license file.
Server Tools The SQL Anywhere server utilities like dbbackup, dberase, dbinit, dblog, dbsvc, dbunload and so on.
Unload Support Support for unloading version 9 and earlier databases.
UltraLite Use to select or deselect all of its subcategories.
The following subcategory is available:
UltraLite Engine The UltraLite engine, utilities, and libraries such as uleng11, ulcond11, ulcreate, ulerase, ullgen11, ullgde11, ulrt11, and ulunload.
Use to select or deselect all of its subcategories.
MobiLink Use to select or deselect all of its subcategories.
MobiLink Client The MobiLink Client tools and libraries such as dblsn, dbmlsync, mlasinst, dbmlsynccli11, and the MobiLink .NET client provider.
MobiLink Server The MobiLink server, tools and libraries such as the server, ODBC driver, JDBC driver, and the MobiLink .NET provider.
QAnywhere The QAnywhere application-to-application messaging tools.
SQL Remote The SQL Remote tools and libraries including dbremote, dbxtract, and the message transport libraries such as dbsmtp11.
Use to select or deselect all of its subcategories.
Sybase Central The Sybase Central database manager and plugins. Use to select or deselect all of its subcategories.
SQL Anywhere Plugin The SQL Anywhere plugin.
MobiLink Plugin The MobiLink plugin.
UltraLite Plugin The UltraLite plugin.
QAnywhere Plugin The QAnywhere plugin.
ISQL The Interactive SQL tool.
DBConsole The administration and monitoring tool for database server connections.
If you would like to determine what files are included in each selectable component, create an MSI installer image selecting all components. A log file is created that details what files are included in every component. This text file can be examined with a text editor. You will see headings like "Feature: SERVER32_TOOLS" and "Feature: CLIENT32_TOOLS". The headings closely correspond to the Deployment Wizard components. This will give you an idea of what is included in each group.
Use the Microsoft Windows Installer to install the deployment file. Here is a sample command:
msiexec /package sqlany11.msi |
A silent install can be performed using a command like the following:
msiexec /qn /package sqlany11.msi SQLANYDIR=c:\sa11 |
/package <package-name> This parameter tells the Microsoft Windows Installer to install the specified package (in this case, sqlany11.msi).
/qn This parameter tells the Microsoft Windows Installer to operate in the background with no user interaction.
SQLANYDIR The value of this parameter is the path to where the software is to be installed.
It is also possible to perform a silent uninstall. The following is an example of a command line that would do this.
msiexec /uninstall sqlany11.msi |
Alternately, a product code can be specified.
msiexec.exe /qn /uninstall {19972A31-72EF-126F-31C7-5CF249B8593F} |
/qn This parameter tells the Microsoft Windows Installer to operate in the background with no user interaction.
/uninstall <package-name> | <product-code> This parameter tells the Microsoft Windows Installer to uninstall the product associated with the specified MSI file or product code.
For more tips on how to do silent installs, see Using a silent install for deployment.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |