New Features and Upgrading Guide
CHAPTER 5. Upgrading to Adaptive Server Anywhere
If you wish to use the new features of Adaptive Server Anywhere Version 6, you need to upgrade your database to Adaptive Server Anywhere 6. The format of the database files is the same as in SQL Anywhere Version 5, but the system tables and available database options have changed.
Caution
Ensure that you back up your database before upgrading.
You can upgrade your database from any of the following versions of the software to Adaptive Server Anywhere Version 6 format:
SQL Anywhere Version 5 Including versions 5.0 and 5.5, all patch levels.
Watcom SQL Version 4 All patch levels.
Watcom SQL Version 3.2 Only patch level e and above.
The upgrade utility carries out the following tasks:
Adds new system tables For example, the SYSJAR and SYSJAVACLASS system tables are new in Version 6, and must be present for any of the Java capabilities of Adaptive Server Anywhere to be available.
Adds new columns to existing tables For example, with the introduction of user-defined data types in SQL Anywhere Version 5, two system tables had a user_type column added.
Adds database options Database options provide a degree of tuning for overall database behavior or for individual user behavior. The list of available options is kept in the system tables, and needs to be upgraded for the options to become available.
To upgrade a database to Adaptive Server Anywhere Version 6 using Sybase Central:Make a backup of your database using the backup utility.
Upgrade the database using the upgrade utility.
To upgrade a database to Adaptive Server Anywhere Version 6 using command line utilities:Make a backup of your database using the backup utility.
Upgrade the database using the upgrade utility.