Preparing to Upgrade

Before you upgrade, run the preupgrade utility. You must have system administrator privileges to perform an upgrade.

The executable files that run the preupgrade and upgrade utilities are SyConfig (a graphical user interface (GUI) application that you start with syconfig.exe), and SyBatch (a command line utility you start with sybatch.exe).

Note: If you are upgrading from a 32-bit server to a 64-bit server, use sybatch.exe.

Each new server version contains features that introduce parameters, commands, reserved words, and so on. preupgrade prepares the old server by making sure all necessary directories and settings are correct for the upgrade. When running preupgrade, manually stop and start the server. You need not start the server before running the syconfig.exe upgrade utility; the utility starts the server when needed.

If you are upgrading from:
- Version 12.5.3 with cache bindings on sybsystemdb – drop the cache bindings for sybsystemdb that are bound to a user-defined cache before you run preupgrade.
- Earlier than version 15.x but later than 12.5.3 – from the Adaptive Server 15.7 ESD #2 installation directory, perform the preupgrade checks on the old server using the preupgrade utility, located in %SYBASE%\%SYBASE_ASE%\upgrade.
Manually drop objects before you execute procedures for the first time. The first time you run the server after an upgrade, the server internally rebuilds procedures from the text in syscomments. The procedure may not execute properly if it contains code that drops, then re-creates, an existing object.

Go to the directory where your current version of Adaptive Server is installed.
Change to the directory ASE-version, where version is your current version of Adaptive Server.
Change to the upgrade directory.
Enter preupgrade to run the preupgrade utility.