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 Server - SQL Usage » Working with Database Objects » Working with databases

Logging SQL statements Next Page

Upgrading databases


The Upgrade Database wizard does not upgrade a version 9.0.2 or earlier database to version 10. To upgrade an existing database to version 10, you must unload and reload the database using dbunload or the Unload Database wizard. See Upgrading SQL Anywhere.

The Upgrade Database wizard helps you upgrade a version 10.0.0 database to a newer version of the software or to restore default settings such as database options, system tables and views, and system procedures, or to add jConnect metadata support.

To upgrade a database (Sybase Central)
  1. Connect to the database.

  2. In the left pane, select the SQL Anywhere plug-in.

  3. In the right pane, click the Utilities tab.

  4. In the right pane, double-click Upgrade Database.

    The Upgrade Database wizard appears.

  5. Follow the instructions in the wizard.


You can also access the Upgrade Database wizard by:

  • Right-clicking the database, and choosing Upgrade Database from the popup menu.

  • Selecting a database, and choosing Upgrade Database from the File menu.

See also

Adding jConnect metadata support to an existing database