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"