Working with utilities
If you have more than one version of SQL Anywhere installed on your computer, you must be aware of your system path when you use the utility. Because the installation will append the latest installed version of the executable directory to your system path, you may have installed a new version of the software, but inadvertently used the old version of the utility.
There are 5 ways to ensure that you use version 10 utilities:
• Modify the system path so that the SQL Anywhere 10 executable directory precedes any other version of the executable path.
• Switch to the executable directory at SQL Anywhere 10 at the command line.
• Specify the full pathname when running the utility.
• Create scripts to change your environment so that you can use the correct version of the utility.
• Uninstall the old version of the software.
Quick Upgrade
The following steps summarize the main steps for upgrading to SQL Anywhere 10:
To upgrade a database using the command line:
1, back up the database. For example: Dbbackup-c "DBF=MYDB.DB;" UID=DBA; Pwd=sql "Old-db-backup-dir" (Note that you are using the correct version of the Backup utility).
2. If necessary, please defragment the disk. Disk fragmentation can easily cause database performance degradation.
3. Close all SQL anywhere and adaptive Server Anywhere database servers because version 10 of the uninstall utility is not available for the running database. For example:
dbstop -c
"DBF=mydb.db;UID=DBA;PWD=sql"。
4, uninstall the old version of the database and load 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. Close the new database and perform the backup. For example:
dbstop -c "DBF=mydb10.db;UID=DBA;PWD=sql"
dbbackup -c "DBF=mydb10.db;UID=DBA;PWD=sql" new-db-backup-dir
Important things in the upgrade:
Before you upgrade, be sure to note the following in your application, which is not only useful for upgrading SQL Anywhere:
• View behavior changes. Read the documentation to determine that the behavior changes in version 10 will not affect your application. If there is a certain impact, please upgrade your application accordingly. See the SQL Anywhere document for changes and upgrades to SQL anywhere.
• Test applications. The application must be fully tested before it is actually put into production.
• Use the correct version of the utility. As mentioned earlier, you must use the correct version of the Use tool.
• Validate and back up the database. Verify and back up the database for the existing software. In addition, recovery cannot take place during a database upgrade, and backing up the database immediately after the upgrade ensures a good recoverability of the database.
• Sync before upgrade. If the database you want to upgrade is part of a synchronization environment, such as an Ultralite database or a remote database of SQL anywhere in a Mobilink installation, you must successfully perform the synchronization before upgrading.
• Test the upgrade process. Carefully test the upgrade process before you really upgrade.
Because SQL Anywhere is actually used in environments under many different configurations, we cannot guarantee that the upgrade guide will ensure that all databases are upgraded successfully.