Rebuilding a database (Sybase Central)

You can use the Unload Database Wizard to upgrade a version 10 or later SQL Anywhere database to the latest version.

Prérequis

Follow the standard precautions for upgrading software. See Upgrade and rebuild precautions.

You must have the SELECT ANY TABLE and the SERVER OPERATOR system privileges.

Ensure that the database is backed up before unloading and reloading it. For example:

dbbackup -c "DBF=mydb.db;UID=DBA;PWD=sql" old-db-backup-dir

Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
Start a version 16 database server running the database you want to upgrade, and then connect to the database from Sybase Central.
Click Tools » SQL Anywhere 16 » Unload Database.
Read the text on the first page of the Unload Database Wizard and then click Next.
Click Unload a database running on a current version of the server, and then select the database from the list. Click Next.
Choose to unload and reload into a new database. Click Next.
Specify a new file name for the database.
You can also specify the page size for the new database, but the page size you specify cannot be larger than the database server page size. The default page size is 4096 bytes. You can encrypt the database file if you want. If you choose strong encryption, you need the encryption key each time you want to start the database. Click Next.
Click Unload structure and data. You can also select any other options you want for your database. Click Next.
Click Unload all database objects. Click Next.
Specify whether you want to connect to the new database when the unload/reload is complete.
Click Finish to start the process.

Résultat

The database is upgraded to the latest version. By default, the database is stopped and restarted.

Suivant

Examine the new database to confirm that the rebuild completed properly and test the upgraded database with your application.