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

Upgrading version 10.0.0 databases Next Page

Rebuilding version 10.0.0 databases

You must unload and reload your database to upgrade its file format.


Unloading and reloading a large database can be time consuming and can require a large amount of disk space. The process may require disk space approximately twice the size of your database to hold the unloaded data and the new database file.

If you are upgrading the file format for a database that is involved in SQL Remote replication or that is a remote database in a MobiLink installation, and if you use the utility, you must be sure to use the -ar or -an option. The option ensures that the transaction log offsets for the new database are set to match those of the old database.


It is recommended that you back up your database before you rebuild it.

To upgrade the database file format (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 > Unload Database.

    The Unload Database wizard appears.

  5. Read the text on the first page of the wizard and then click Next.

  6. Choose to unload the database to which you are connected. Click Next.

  7. Choose to unload the database that is already running. Click Next.

  8. Specify a new filename for the database. Click Next.

  9. You can specify the page size for the new database. The default page size is 4096 bytes. You can encrypt the database file if you want. You need the encryption key each time you want to start the database.

    For more information about database file encryption, see Encrypting a database.

  10. Choose Unload Structure and Data. You can also select any other options you want for your database. Click Next.

  11. Choose Unload All Database Objects. Click Next.

  12. Specify whether you want to connect to the new database when the unload/reload is complete.

  13. Click Finish to start the process. You should examine the new database to confirm that the rebuild completed properly.

    For more information about using the Unload Database wizard, see Using the Unload Database wizard.

To upgrade the database file format (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. Execute the Unload utility (dbunload) using the -ar option to create a new database.

    dbunload -c "connection-string" -an new-db-file

    The database user specified in the connection-string must connect to the database to be unloaded with DBA authority.

    This command replaces the existing database with an upgraded database. To use the -ar option, you must connect to a personal server, or to a network server on the same computer as the Unload utility (dbunload).

    For information about other Unload utility (dbunload) options, see Unload utility (dbunload).

  4. Shut down the database and archive the transaction log before using the reloaded database.

    If you want to change the characteristics of the database during unload and reload (for example, change a case-sensitive database to a case-insensitive database), the procedure is more involved. For more information, see Rebuilding databases.