Adaptive Server Upgrades

You can upgrade from version 15.5 and later of a nonclustered Adaptive Server to version 15.7 of the Cluster Edition.

You can upgrade to the Cluster Edition from these noncluster versions of Adaptive Server:

15.0 through 15.5
12.5 through 12.5.4 ESD #10

You can upgrade to the current Cluster Edition from these earlier Cluster Editions:

15.0.3 Cluster Edition
15.0.1 Cluster Edition through 15.0.1 Cluster Edition ESD #4

Once you have upgraded to the 15.5 or later Cluster Edition, you cannot downgrade to a nonclustered 15.x or earlier server. You can, however, downgrade to 15.0.1 Cluster Edition through 15.0.1 Cluster Edition ESD #4, Cluster Edition 15.0.3, and Cluster Edition 15.5.

Note: The sybcluster utility does not have a built-in tool to perform an upgrade or downgrade between two versions of Adaptive Server Cluster Edition.

Upgrade Adaptive Server using the Adaptive Server plug-in or sybcluster, or manually.

If your server has replicated databases, consult the Replication Server Configuration Guide before starting the preupgrade tasks.

Only upgrades to and from the same page size are supported. Use sybmigrate to re-create the schema and load data from one page size to another. See the Utility Guide.

To upgrade from a shared-installation mode to a private-installation mode in Adaptive Server 15.5 Cluster Edition, see to the Release Bulletin for special upgrade instructions.

Adaptive Server version 15.7 includes both new and changed system catalogs that may affect your existing applications. See the Adaptive Server Enterprise New Feature Guide for a complete list. Sybase recommends that you do not use the new features until you are committed to staying with 15.7.

Note: When upgrading a 12.5.4 or earlier database to the Cluster Edition, make sure you execute all steps in the upgrade sequence from the same node. That is, you must load the database and execute online database on the same node.

Upgrading Adaptive Server
A minor change was made to the format of a log record in both the cluster and nonclustered editions of Adaptive Server 15.5 and later versions.
Considerations for Component Integration Services
If you have both a local and a remote server running on Adaptive Server version 15.x and are upgrading both of them to version 15.7, upgrade the local server first. If you plan to upgrade one server but not the other, upgrade the local server.
Preparing to Upgrade
Before you upgrade, run the preupgrade utility. You must have system administrator privileges to perform an upgrade.
Changes in Adaptive Server Directories
The directory structures for Adaptive Server installations differ depending on version.
Checking System and Upgrade Requirements
Verify that your system meets upgrade requirements.
Performing Preupgrade Tasks
To ensure a successful upgrade, review and perform the preupgrade tasks as necessary. Depending on the old server configuration, you may not need to perform all preupgrade tasks.
Upgrade to Adaptive Server 15.7
After you successfully run the preupgrade utility, you are ready to upgrade Adaptive Server.
Postupgrade Tasks
After you have upgraded, make sure your new Adaptive Server is up and running.
Migrate
You can migrate from a nonclustered to the Cluster Edition of Adaptive Server.
Adaptive Server Components and Related Products
After you finish upgrading Adaptive Server, upgrade its components and related products.