Teach you how to upgrade to SQL Anywhere10 (10)

Upgrade Qanywhere

To upgrade the Qanywhere application, you can upgrade the consolidated database, application, and client message stores.

To upgrade the consolidated database, refer to the previous document.

Please read the new features and behavior changes carefully to upgrade your application.

Upgrading the Qanywhere message store

1, deploy the Qanywhere file.

2. Upgrade message storage:

Use the-SU or-sur option to start the Qanywhere agent.

Upgrade Ultralite

When upgrading an older version of Ultralite, you must consider the required database and the application code upgrade path.

Compatible with existing software

· The Ultralite 10 runtime and the Ultralite 10 engine cannot work with an earlier version of the Ultralite database file and the application code

· Ultralite 10 will not support the application from the client to an Ultralite version database connection other than Ultralite version 10

• Provides the following database and client-side application features to manage earlier versions in Sybase Central:

O Full Management version 10 database. The earlier version of the database could not be managed.

O can only connect to versions 5, 6, 7, 8, or 9 databases to upgrade the database file format.

O can use the Migrate C + + API Wizard for version 7, 8, or 9 of C + + application source file upgrades.

If you have more than one version of SQL Anywhere on your computer, you must be aware of the Ultralite utility's system path.

Upgrading an Ultralite Database

To upgrade an earlier version of the Ultralite database, you need:

• Synchronizing Data

• Disconnect all application and management tools

• Copy the database to the computer

Attention:

Before you upgrade, you cannot connect to an earlier version of the database with the Ultralite 10 administration tool.

Special Considerations for Database upgrades

· Ultralite mode does not now exist as a separate. USM file and becomes part of the database. This means that if you are not connected to a database, you cannot create a new database. The application must deploy an initialized database or programmatically create a database using the new CreateDatabase feature.

• The file format is also unified in version 10. This means that most platforms can share the same database and no longer need Unicode characters.

If you need to use characters that are not included in your sort, you need to encode the database as UTF-8.

Windows CE and Desktop databases

If you upgrade from the above two platforms and do not require Unicode characters, you do not need to UTF-8 the encoding database.

UTF-8 encoding may cause unnecessary expansion of the database.

• In the newly created version 10 database, all passwords are case-sensitive, regardless of whether the database is case sensitive or not. Therefore, user names, passwords, and so on may not be retained when the database is upgraded. You must add a username and password to the Ultralite 10 database. The default new password for the DBA is SQL.