User's Manual

Chapter 3. 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.