Upgrading version 10 and later databases

Upgrading a database adds and modifies system tables, system procedures, and database options to enable version 12 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 12. To upgrade an existing version 9.0.2 or earlier database to version 12, 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 12 » Administration Tools » Sybase Central.

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

  4. Choose Tools » SQL Anywhere 12 » 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 12 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. 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:

    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

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0