Teach you how to upgrade to SQL Anywhere 10 (2)

Source: Internet
Author: User
Tags command line dba backup

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.