What's New in SQL Anywhere Studio
  Upgrading Software and Databases
    Upgrading Adaptive Server Anywhere

Upgrading a database

Upgrading a database adds and modifies system tables, system procedures and database options to enable version 9 features. It does not change the file format used to store and access data on disk and so does not give access to all new features and performance enhancements in the latest version of the software.

For information on upgrading the database file format, see Upgrading the database file format.

To upgrade a database (Sybase Central)

1. Carry out the standard precautions for upgrading software.

   See Standard upgrade precautions.

2. Start a version 9 database server running the database you wish to upgrade.

3. From Sybase Central, connect to the database you wish to upgrade.

4. Right click the database and choose Upgrade Database from the popup menu. The Upgrade a Database wizard appears.

5. Follow the instructions in the wizard.

6. Shut down the database and archive the transaction log before using the upgraded database.

To upgrade a database (Command line)

1. Carry out the standard precautions for upgrading software.

   See Standard upgrade precautions.

2. Ensure that you have exclusive access to the database to be upgraded.

3. Ensure that the version 9 utilities are ahead of other utilities in your system path.

   See Using the utilities.

4. Execute the Upgrade [dbupgrad] utility against the database:

   dbupgrad -c "connection-string"

   The connection-string must connect to the database to be unloaded, with DBA authority.

   For more information, see Upgrading a database using the dbupgrad command-line utility.

5. Shut down the database and archive the transaction log before using the upgraded database.

To upgrade a database (SQL)

1. Connect to the database from Interactive SQL or another application that can execute SQL statements.

2. Execute the ALTER DATABASE statement. Use the JAVA clause to specify whether you wish to upgrade the JDK level used by Java applications in the database.

   For example, the following statement upgrades a database without altering the JDK level:

   ALTER DATABASE UPGRADE

   For more information, see ALTER DATABASE statement.