Upgrading version 10 and later databases

Upgrading a database adds and modifies system tables, system procedures, and database options to enable version 11 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 about upgrading the database file format, see Rebuilding version 10 and later databases.

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

Caution

You should always 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. For information about backing up your database, see Backup and data recovery.

To upgrade a database (Sybase Central)
  1. Carry out the standard precautions for upgrading software. See Important upgrade precautions.

  2. Choose Start » Programs » SQL Anywhere 11 » Sybase Central.

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

  4. Choose Tools » SQL Anywhere 11 » Upgrade Database.

  5. Follow the instructions in the Upgrade Database Wizard.

  6. 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 choosing Upgrade Database.

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

To upgrade a database (Command line)
  1. Carry out the standard precautions for upgrading software. See Important upgrade precautions.

  2. Ensure that you have exclusive access to the database to be upgraded and ensure that the version 11 utilities are ahead of other utilities in your system path. See Using the utilities.

  3. Run the Upgrade utility (dbupgrad) against the database:

    dbupgrad -c "connection-string"

    The database user specified in the connection-string must have DBA authority on the database to be upgraded.

    For more information, see Upgrade utility (dbupgrad).

  4. 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 an ALTER DATABASE statement.

    For example, the following statement upgrades a database:

    ALTER DATABASE UPGRADE;

    For more information, see ALTER DATABASE statement.

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


Upgrading SQL Anywhere software and databases in a database mirroring system