Chapter 7: Upgrading from an Earlier Version


Overview

You can upgrade to the Cluster Edition from:

You cannot directly upgrade from 12.5.4 including ESDs nor can you directly downgrade from 15.0.2. If you have any of these versions and want to install the Cluster Edition you must first:

To upgrade from 15.0.1 to the Cluster Edition, you must use the upgrade procedures described in this manual. For more information on migrating from unsupported version see “Migrating to the Cluster Edition from Unsupported Editions”.

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

You can upgrade the server manually, or use the sybcluster utility, which performs many of the preupgrade and upgrade steps for you.

See “Migrating to the Cluster Edition” for information about migration.

Manually upgrading Adaptive Server consists of six processes:

  1. Perform pre-upgrade tasks.

  2. Back up your database.

  3. Install the new server into its own installation directory.

    NoteYou must have both the old installation and the new installation to perform an upgrade.

  4. Run preupgrade from the Cluster Edition release location.

    Each new version of Adaptive Server contains different features that introduce new parameters, commands, reserved words, and so on. For this reason, preupgrade is used for preparing the old server for upgrade.

  5. Run the pre upgrade utility against the old servers to update the underlying schema so that their structures are correct for the new server.

    NoteYou see advisory warnings when configuration parameters are not set to the default. These do not require any action.

  6. Perform post-upgrade tasks.