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

 

Rebuilding (unloading/reloading) a database

For previous users of the software, this task summarizes the process for rebuilding your database to version 16.

Prerequisites

For version 16 databases, you must have the following system privileges:

  • BACKUP DATABASE

  • VALIDATE ANY OBJECT

  • SERVER OPERATOR

  • SELECT ANY TABLE

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

Back up the database. For example:

dbbackup -c "DBF=mydb.db;UID=DBA;PWD=sql" old-db-backup-dir
 Rebuild a database (command line)

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

  2. Shut down all SQL Anywhere database servers because the version 16 dbunload utility cannot be used against a database that is running on a previous version of the database server. For example: 

    dbstop -c "DBF=mydb.db;UID=DBA;PWD=sql"

  3. Unload and reload (rebuild) the old database into a new version 16 database. For example:

    dbunload -c "DBF=mydb.db;UID=DBA;PWD=sql" -an mydb16.db

  4. Back up the new database before using it. For example:

    dbbackup -c "DBF=mydb16.db;UID=DBA;PWD=sql" new-db-backup-dir

  5. Validate the new database before using it. For example:

    dbvalid -c "DBF=mydb16.db;UID=DBA;PWD=sql"

Results

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

Next

You can test the rebuilt database with your application.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0