You can upgrade to Adaptive Server 15.0.2 from any of these versions:
11.9.2.6 and later
12.0.x
12.5.x (except 12.5.3a)
Adaptive Server version 15.0.2 does not support upgrade
from Adaptive Server version 12.5.3a.
For a server installation 11.5.x and older, Sybase recommends that you upgrade to version 12.5.4, then upgrade to version 15.0.2.
You can upgrade Adaptive Server from a 32-bit version to a 64-bit version, but you cannot move from a 64-bit version to a 32-bit version. Likewise, you can upgrade only from an earlier version of Adaptive Server to a more recent version.
Only upgrades to and from the same page size are supported. Changing the server schema from one page size to another is a database migration. See sybmigrate in the Utility Guide for information about migration.
Upgrading Adaptive Server consists of three processes:
Install Adaptive Server 15.0.2 into its own installation directory.
You must have both the old installation and the new
installation to perform an upgrade.
If your server is a pre-15.x version then, from the 15.0.2 server installation, perform the pre-upgrade checks on the old server using the preupgrade utility, which is located at $SYBASE/ASE-15_0/upgrade. If necessary, fix any problems that pre-upgrade process reports. If your server is already at Adaptive Server 15.x or later most of this process is automatic when you install the new server.
preupgrade runs against the pre-15.0.x servers. It checks that all required databases exist and that they are large enough. It verifies that stored procedures have the text required for upgrade, and that configuration parameters are correct for the new server and for upgrading. It verifies that datatype definitions do not conflict with the new server’s requirements. When preupgrade runs without reporting any errors, you can then:
Shut down the pre-15.0.x server.
Start the 15.0.2 server against the old installation.
Copy files from old $SYBASE directory to the new $SYBASE/ASE-15_0/upgrade directory.
Run the upgrade process. If problems occur, fix them and then run the upgrade process again.
Reinstall Sybase-supplied stored procedures to prevent any errors caused from changes to system catalogs.
Adaptive Server issues advisory warnings when configuration parameters
are not set to the default. These do not require any action.
The preupgrade and upgrade utilities are internally called by sqlupgrade or sqlupgraderes. If your server is already at a 15.x level, you do not need to run preupgrade in order to move to version 15.0.2. All required changes happen automatically while Adaptive Server 15.0.2 is starting for the first time. However you must reinstall system stored procedures by running the install scripts noted in the steps above. If you are starting from a pre-15.x server you must run preupgrade before upgrading to the new 15.x server.
Each new version of Adaptive Server contains features that introduce new parameters, commands, reserved words, and so on. For this reason, preupgrade is needed to prepare the old server for upgrade. It is not necessary to start the server before running sqlupgrade. sqlupgrade will start the server when needed. However, if you are running preupgrade, then you will need to manually stop and start the server.
preupgrade runs various checks to determine how much space you must add to the old server to successfully upgrade.
As part of the pre-upgrade tasks, preupgrade scans all databases and catalogs and determines how much free space is required to upgrade successfully. preupgrade searches for the largest catalog, then calculates the required free space by doubling the size of the largest catalog, and adding 10 percent for logging the upgrade changes for each catalog.
During the pre-upgrade process, preupgrade returns informational messages as it checks the old server. You must fix all reported problems, and run preupgrade cleanly before beginning the upgrade process. Once the old server is eligible to be upgraded you need to manually shut down the old server, and start the new server against the existing databases. Then begin the upgrade process.
Following an upgrade to other platforms, Adaptive Server internally rebuilds procedures from the text in syscomments the first time Adaptive Server is executed. The procedure may not execute properly if it has code that drops an existing object and recreates it. This is a problem when the object already exists at the time the procedure is first executed. To avoid problems manually drop the object prior to executing the procedure for the first time.
