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

Upgrading Mobilink

Compatible with existing software

• The new Mobilink client can be compatible with an earlier version of the Mobilink server.

• The new Mobilink server can use an earlier version of the client or be mixed with a version 10 client. If you want to use an earlier version of the client, start the Mobilink server with the-XO option.

· The Mobilink server version 10 supports only versions 8 and 9 of SQL anywhere and Ultralite clients. If you need to support an earlier version of the client, you must support it with an earlier version of the Mobilink server.

• Confirm that the behavior changes in publication 10 listed in the SQL anywhere document will not affect your application. If there is an impact, please upgrade the application accordingly.

Upgrade Step

To upgrade an existing Mobilink installation, you must follow these steps to upgrade the components:

1, shut down the Mobilink server.

2, upgrade the consolidated database.

3, upgrade the Mobilink server.

4, start the Mobilink server.

5, upgrade the Mobilink client.

Before you upgrade, read carefully the important things in your behavior changes and upgrades.

Before you can use the new Mobilink server on an existing consolidated database, you must run the upgrade script to install the new system objects. The upgrade script must be installed through an existing installed Mobilink system table owner.

Upgrading the Consolidated Database

Attention:

If you write a authenticate_user_hased script, you must use the equivalent data type to accept the binary (20)

Accept binary (32) instead.

Upgrade SQL Anywhere

Prior to this release, the Mobilink system table was owned by dbo. To run the setup script on the SQL anywhere database, you must log on to the consolidated database by using the owner of the Mobilink system table. Using a normal user's permissions is not sufficient to run a script that changes the table. To run the upgrade script, you can use the SETUSER SQL statement to simulate dbo. For example:

SETUSER "dbo";

If you are upgrading the consolidated database in Sybase Central, you must use the grant Connect statement to create a password for the dbo and connect in dbo. For example:

GRANT CONNECT to "dbo" identified by ' password ';

When you have finished upgrading, you must use grant connect to remove the dbo password. For example:

GRANT CONNECT to "dbo";

• If you have configured the SQL Anywhere consolidated database but never synchronized with it, you must run the setup script (not the upgrade script). This applies only to the SQL Anywhere consolidated database.