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

Using the utilities Next Page

Upgrade quick start

For previous users of the software, the following steps summarize the process for upgrading your database to version 10.

To upgrade a database (command line)
  1. Back up the database. For example:

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

    Make sure you use the correct version of dbbackup to back up your database. See Using the utilities.

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

    For an alternative procedure to defragmenting, see Rebuilding a version 9 or earlier database without defragmenting.

  3. Shut down all SQL Anywhere and Adaptive Server Anywhere database servers because the version 10 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"
  4. Unload and reload (rebuild) the old database into a new version 10 database. For example:

    dbunload -c "DBF=mydb.db;UID=DBA;PWD=sql" -an mydb10.db -o dbunload_log_mydb.txt
  5. Shut down the new database and back it up before using it. For example:

    dbstop -c "DBF=mydb10.db;UID=DBA;PWD=sql"
    dbbackup -c "DBF=mydb10.db;UID=DBA;PWD=sql" new-db-backup-dir
See also