What's New in SQL Anywhere Studio
Upgrading Software and Databases
You can run multiple versions of Adaptive Server Anywhere (for example version 8.0 and version 9.0) simultaneously, provided that only one of the versions uses SPX.
Adaptive Server Anywhere database servers work with older databases. There is no need to upgrade your database in order to continue working with existing applications.
You should not use older versions of the Adaptive Server Anywhere database server with newer databases.
For Adaptive Server Anywhere software version 6.0.0 or later, you can upgrade the database server without upgrading client software.
Version 9 database servers support connections from client applications using software from version 6.0.0 or later.
Management of old databases and old database servers from the current version of Sybase Central is provided as follows:
Full management of version 7 and later databases running on version 7 and later servers.
You can connect to a version 5 or 6 database on a version 8 or later database server only to upgrade the database file format using the Unload Database wizard.
There is no support for version 6 and earlier databases running on version 7 and older database servers.
For information on upgrading client/server installations from Version 5 and earlier, see Upgrading Version 5 Applications.
You must upgrade your database if you wish to use some of the new features in this version of the software.
There are two kinds of upgrade possible with version 9:
Upgrade the database Use the Upgrade [dbupgrad] utility to upgrade your database. This process updates the system tables, provides new database options, adds or modifies system procedures.
Upgrading the database can be done in-place on your existing database file. It does not require that you unload and reload your database.
See Upgrading a database.
Upgrade the database file format Some features, such as new index types, require a new database file format. The Upgrade [dbupgrad] utility does not change the format of the database file.
To upgrade the database file format, you must unload and reload your database.
Upgrading a database
Upgrading the database file format
Standard upgrade precautions
Using the utilities