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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16 » The rebuild process for version 9 and earlier databases

 

Rebuilding a version 9 or earlier database (Sybase Central)

The Unload Database Wizard rebuilds a version 9 or earlier database by unloading into a reload file and data files, unloading and reloading into a new database, or unloading and reloading into an existing database. Rebuilt databases support all new features and performance enhancements in the latest software version.

Prerequisites

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

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

The database file must be located on the same computer as the SQL Anywhere 16 installation.

You cannot unload a subset of tables from a database. Use the dbunload utility to do this.

If the Unload Database Wizard determines that the database file is already running, then the database is stopped before the unload proceeds.

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

If possible, defragment the drive where the new database will be stored because a fragmented drive can decrease database performance.

Ensure that you have exclusive access to the database to be unloaded and reloaded. No other users can be connected.

 Rebuild a version 9 or earlier database (Sybase Central)
  1. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. Click Tools » SQL Anywhere 16 » Unload Database.

  3. Read the introductory page of the Unload Database Wizard, and click Next.

  4. Click Unload a database running on an earlier version of the server, or a database that is not running. Specify the connection information for the database. Click Next.

  5. Click Unload and reload into a new database. Click Next.

  6. Specify a new file name for the database. Click Next.

    You can specify the page size for the new database. In version 16, the default (and recommended) page size is 4096 bytes.

    You can encrypt the database file. If you choose strong encryption, you need the encryption key each time you start the database. See Database encryption and decryption.

  7. Choose to unload structure and data. Click Next.

  8. Specify whether you want to connect to the new database when the rebuild is complete.

  9. Click Finish. Examine the new database to confirm that the rebuild completed properly.

Results

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

Next

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

 See also