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.

This change introduces an unlikely possibility for Adaptive Server to misinterpret this changed log record in cases where the upgraded server contains a database that is the primary database for replication.

This change should not affect your upgrade process; however, it requires you to strictly follow some steps when you move from Adaptive Server 15.0.x or earlier to Adaptive Server 15.5.x and later (nonclustered editions). See the following table for all possible combinations of upgrades.

An upgrade is done by:
Upgrading Your Entire Installation
Current Version Upgrading to Special Upgrade Information
Adaptive Server 15.0.x or earlier Adaptive Server 15.7.x

If you are using Replication Server to replicate one or more databases in the version to be upgraded, ensure that all transactions have been replicated before the polite shutdown is done, by draining the log. See Upgrading Adaptive Server in a Replication System and Upgrading Replication Server in the Replication Server Configuration Guide for your platform.

Adaptive Server 15.0.x Adaptive Server Cluster Edition 15.7.x

If you are using Replication Server to replicate one or more databases in the installation to be upgraded, ensure that all transactions have been replicated before the polite shutdown is done, by draining the log, See the Upgrading Adaptive Server in a Replication System and Upgrading Replication Server in the Replication Server Configuration Guide for your platform.

Adaptive Server 15.5.x or later Adaptive Server Cluster Edition 15.7.x

Not supported.

Adaptive Server Cluster Edition 15.5.x or later Adaptive Server 15.7.x

Upgrading any version of Adaptive Server Cluster Edition to a nonclustered version is not supported.

Adaptive Server 15.5.x Adaptive Server 15.7.x

No special upgrade instructions.

Adaptive Server Cluster Edition 15.5.x or later Adaptive Server Cluster Edition 15.7.x

In the installer destination directory pane, enter the 15.5.x directory, then choose Update.

After your installation, install the new system procedures (from $SYBASE/ASE-15_0/scripts/installmaster).

Upgrading a Single Database
Current Version Upgrading to Special Upgrade Instructions
Adaptive Server 15.0.x and earlier Adaptive Server 15.7.x

When you use online database to upgrade a single database in Adaptive Server 15.7.x (either the cluster or noncluster edition) after loading a database dump and transaction logs from Adaptive Server 15.0.x or earlier, if the database you are upgrading is also replicated, make sure the database's transaction log is truncated before you turn replication back on.

Adaptive Server 15.5.x or later Adaptive Server Cluster Edition 15.7.x

Upgrading a single database from the nonclustered edition of 15.5 or 15.5 ESD #1 to cluster edition of 15.5 or 15.5 ESD #1 is supported, and no additional steps are required.

Adaptive Server Cluster Edition 15.5.x or later Adaptive Server 15.7.x

Upgrading a database from any version of the Cluster Edition to a nonclustered version is not supported.

Adaptive Server 15.5.x Adaptive Server 15.7.x

No special upgrade instructions.

Adaptive Server Cluster Edition 15.5.x Adaptive Server Cluster Edition 15.7.x

No special upgrade instructions.

Related concepts
Installation of Version 15.7 SP100 over an Existing 15.x Adaptive Server
Related tasks
Reenabling Replication Server After the Dataserver Upgrade
Postupgrade Tasks