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 (Sybase Central)

You can use the Upgrade Database Wizard 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

You must have the following system privileges:

  • ALTER DATABASE

  • BACKUP DATABASE

  • SERVER OPERATOR

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

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. To back up your database, you must have the BACKUP DATABASE system privilege. For information about backing up your database, see Backup and data recovery.

Context and remarks

The Upgrade Database Wizard does not upgrade a version 9.0.2 or earlier database to version 16. To upgrade an existing version 9.0.2 or earlier database to version 16, you must unload and reload the database using dbunload or the Unload Database Wizard. See Upgrading version 9 and earlier databases.

 Upgrade a database (Sybase Central)

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

  2. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  3. From the SQL Anywhere 16 plug-in, connect to the database you want to upgrade. The database must be running on a version 16 database server.

  4. Click Tools » SQL Anywhere 16 » Upgrade Database.

  5. Follow the instructions in the Upgrade Database Wizard. By default, the database is stopped and restarted.

  6. (Optional) Stop the database and archive the transaction log by making a copy of it before using the upgraded database if you did not choose to do so in the wizard.

    Tip

    You can also access the Upgrade Database Wizard by:

    • Right-clicking a database, and clicking Upgrade Database.

    • Selecting a database, and clicking File » Upgrade Database.

Results

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

Next

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

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0