Adaptive Server Upgrades

You can upgrade to Adaptive Server version SP100 from versions 12.5.4 through 15.7.

Upgrades are supported from:

Nonclustered to nonclustered Adaptive Server
Cluster Edition to Cluster Edition
Nonclustered Adaptive Server to Cluster Edition

You cannot upgrade from Adaptive Server Cluster Edition to a nonclustered edition.

If you are upgrading from a nonclustered Adaptive Server versions 15.0 through 15.5 to Adaptive Server version 15.7 SP100 Cluster Edition, you must upgrade to the nonclustered version of Adaptive Server 15.7 SP100 before upgrading to the Cluster Edition of SP100.

You can upgrade to this version of Adaptive Server from:

Adaptive Server 15.0 through 15.0.3 (but not the 15.0.1 or 15.0.3 of the Cluster Edition) – to install version 15.7 on top of an earlier 15.x version. This is considered a minor upgrade or update, and you can perform this through the Adaptive Server installer.
Adaptive Server 12.5.x – to upgrade from Adaptive Server 12.5.4 or earlier, execute the upgrade sequence from the same node on which the database resides. This is a major upgrade, and requires that you perform preupgrade tasks.

You can upgrade from a 32-bit version to a 64-bit version, but you can neither upgrade nor move from a 64-bit to a 32-bit:

You cannot upgrade to this version of Adaptive Server from:

Adaptive Server version 11.9.x
Adaptive Server version 12.0.x

SAP recommends that you first upgrade to version 12.5.4 or later before upgrading to version 15.7 SP100.

If your server has replicated databases, consult the Replication Server Configuration Guide before starting the upgrade preparatory 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.

Adaptive Server version 15.7 SP100 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. SAP recommends that you do not use the new features until you are committed to staying with 15.7.

Verify that the version of Adaptive Server you are upgrading from is compatible with Adaptive Server version 15.7 SP100.

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 SP100, upgrade the local server first. If you plan to upgrade one server but not the other, upgrade the local server.
Preparing to Upgrade
If you are performing a major upgrade from an Adaptive Server version earlier than 15.x, 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.
Performing Tasks Before Upgrading
To ensure a successful upgrade, review and perform preparatory tasks as necessary. Depending on the old server configuration, you may not need to perform all preparatory tasks.
Upgrade to Adaptive Server 15.7 SP100
If you are performing a major upgrade from an Adaptive Server version earlier than 15.x, you are ready to upgrade Adaptive Server after you successfully run the preupgrade utility.
Postupgrade Tasks
After you have upgraded, make sure your new Adaptive Server is up and running.
Migrate
You can migrate from 32-bit to 64-bit versions on different computers or partitions.
Adaptive Server Components and Related Products
After you finish upgrading Adaptive Server, upgrade its components and related products.