Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Changes and Upgrading » Upgrading to SQL Anywhere 10 » Upgrading SQL Anywhere

Important upgrade precautions Next Page

Upgrading version 10.0.0 databases


Upgrading a database adds and modifies system tables, system procedures, and database options to enable version 10 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.0.0 databases.

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

  2. Start Sybase Central.

    From the Start menu, choose Programs > SQL Anywhere 10 > Sybase Central.

  3. Start a version 10 database server running the database you want to upgrade.

  4. From the Tools menu, choose SQL Anywhere 10 > Upgrade Database.

    The Upgrade Database wizard appears.

  5. Follow the instructions in the wizard.

  6. Stop the database and archive the transaction log before using the upgraded database.

    For more information about using the Upgrade Database wizard, see Upgrading databases.

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 10 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 connect to the database to be unloaded with DBA authority.

    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 without changing the JDK level:

    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.