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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Programming » Database and application deployment


The Deployment Wizard

The SQL Anywhere Deployment Wizard is the preferred tool for creating 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

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

    • A MergeModule.CAB cabinet file stored as a stream inside the merge module. This cabinet file contains all the files required by the components delivered by the merge module. Every file delivered by the merge module must be stored inside of a cabinet file that is embedded as a stream in the merge module's structured storage. In a standard merge module, the name of this cabinet is always MergeModule.CAB.

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.

If you want to determine what files are included in each selectable component, create an MSI installer image and select all the components. A log file is created that specifies what files are included in every component. This text file can be examined with a text editor. There are headings such as Feature: SERVER32_TOOLS and Feature: CLIENT64_TOOLS that closely correspond to the Deployment Wizard components. Looking at the file gives you an idea of what is included in each group.

To run the Deployment Wizard, click Start » Programs » SQL Anywhere 12 » Administration Tools » Deploy to Windows.

Make sure to record the product code that was used to create the deployment package. You can use the product code at a later time to uninstall the package.


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.

 See also

Running the Deployment Wizard
Deployment package installation utility