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

SQL Anywhere 11.0.0 » SQL Anywhere 11 - Changes and Upgrading » Upgrading to SQL Anywhere 11 » Upgrading SQL Anywhere

 

Upgrade quick start

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

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

    Alternatively, you can stop all running database servers and make a file copy of the database and transaction log.

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

  3. Shut down all SQL Anywhere and Adaptive Server Anywhere database servers because the version 11 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 11 database. For example:

    dbunload -c "DBF=mydb.db;UID=DBA;PWD=sql" -an mydb11.db
  5. Back up the new database and before using it. For example:

    dbbackup -c "DBF=mydb11.db;UID=DBA;PWD=sql" new-db-backup-dir
  6. Validate the new database before using it. For example:

    dbvalid -c "DBF=mydb11.db;UID=DBA;PWD=sql"
See also