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

Upgrade Adaptive Server Enterprise, Oracle, or Microsoft SQL Server databases

1. If you upgrade from version 6.x, you need to run the Mobilink setup script that is located in the Mobilink\setup subdirectory under the SQL Anywhere installation directory. If you upgrade from an updated version, you do not need to run the setup script.

2, run the appropriate upgrade script.

The upgrade pin name is upgrade_xxx.sql,xxx the type of the consolidated database. Their mobilink\upgrade\version,version in the SQL Anywhere installation directory is the version of SQL anywhere before the upgrade.

For example:

READ 'c:\Program Files\SQL Anywhere
10\MobiLink\upgrade\902\upgrade_asa.sql'

Upgrading the DB2 Database

1. Copy the Mobilink\setup\syncdb2long.class file to the Sqllib\function directory of the computer where the DB2 server resides. You may have to restart the DB2 instance.

2. If you are upgrading from Mobilink version 6, you will need to run

MobiLink\setup\syncdb2long.sql

Set up SQL scripts to create Mobilink system tables and stored procedures.

3, positioning DB2 upgrade script.

The upgrade foot name is:

upgrade_db2tolong.sql

A mobilink/upgrade/version subdirectory located in the SQL Anywhere installation directory. Version represents the versions of Mobilink before the upgrade.

4, copy and modify the Upgrade_db2tolong.sql file. Modify the Connect statement at the beginning of the file to the instance you want to connect to. Apply this SQL script to the consolidated database.