Install the most recent version of the operating system that has been certified for Adaptive Server.
Check that you have enough disk space. See your installation guide for requirements.
Check that each database has at least 10% free space. This is needed by the upgrade.
Check your applications to assess impact from SQL changes. See Chapter 4, “Making Required Application Changes.”
Check for new reserved words, including those in scripts and applications. See “New reserved words” in this manual.
Replace obsolete environment variables in applications and scripts.
Record size and device fragment information for all databases. You can query the sysdevices and sysusages tables for this information.
Make a note of the default character set and sort order. See the System Administration Guide for information about character sets and sort order.
Verify that sybsystemprocs is large enough and that all device fragments, if there are multiple fragments, contain both log and data segments. See “sybsystemdb”in Chapter 5, “Making Database Administration Changes.”
Just before upgrading:
Set master as the default database for “sa”.
If the locations of your error log and configuration file are not the default locations, change them to the default location.
Back up:
All databases
devices
Sybase directory
(For Windows) Sybase entries in the Registry
bcp out critical system tables:
syslogins
sysloginroles
sysdatabases
sysusages
sysdevices
On Windows, change the service type for Adaptive Server to “manual.”
Disable mirroring.
Use sp_auditoption “enable auditing”, “off” to disable auditing.
Save the server configuration (.cfg) file.
