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.

Prérequis

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.

Caution

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)

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.

Résultat

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

Suivant

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