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.
Prerequisites
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.
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.
Execute an ALTER DATABASE statement.
For example, the following statement upgrades a database:
ALTER DATABASE UPGRADE; |
Shut down the database and archive the transaction log before using the upgraded database.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |