Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16 » The upgrade process for version 10 and later databases


Upgrading a version 10 or later database (SQL)

You can use the ALTER DATABASE statement to upgrade a version 10 or later database by adding and modifying system tables, system procedures, and database options to enable version 16 features.


Follow the standard precautions for upgrading software. See Upgrade and rebuild precautions.

You must be the owner of the database or have ALTER DATABASE system privilege, and must be the only connection to the database.


Back up your database files before upgrading. If you apply the upgrade to the existing files, then these files become unusable if the upgrade fails.

 Upgrade a database (SQL)
  1. Connect to the database from Interactive SQL or another application that can execute SQL statements. No other connection can be using the database at the same time.

  2. Execute an ALTER DATABASE statement.

    For example, the following statement upgrades a database:

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


The database is upgraded and contains new and modified system tables, system procedures, and database options.


You should examine the new database to confirm that the upgrade completed properly and test the upgraded database with your application.

 See also