SQL Remote User's Guide
  Setting Up SQL Remote

Upgrading SQL Remote for Adaptive Server Enterprise

This section describes the procedure for upgrading SQL Remote for Adaptive Server Enterprise.

As a SQL Remote installation may consist of a large number of databases, it is generally not practical to upgrade software on all machines at the same time. SQL Remote is designed so that upgrades can be carried out incrementally. It is not important what order SQL Remote machines are upgraded, as the message format is compatible with previous releases.

To upgrade SQL Remote

1. Back up both the consolidated database and, if it is separate, the stable queue database.

2. Install the new SQL Remote for Adaptive Server Enterprise software.

3. Run the script ssupdate.sql at the consolidated database to upgrade the SQL Remote system tables and procedures.

   The ssupdate.sql script is held in your Sybase directory.

4. Run the script squpdate.sql at the stable queue database to upgrade the SQL Remote stable queue tables and procedures.

   The squpdate.sql script is held in your Sybase directory.

The software is now upgraded.