Chapter 3. Setting Up SQL Remote
Upgrading SQL Remote for Adaptive ServerEnterpriseThissection describes the procedure for upgrading SQL Remote for
AdaptiveServer Enterprise.
Asa SQL Remote installation may consist of a large number of databases, it
isgenerally 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.
❖Toupgrade SQL Remote
1. Back up both the consolidated database and, if it is separate, the stable
queuedatabase.
2. Install the new SQL Remote for Adaptive Server Enterprise software.
3. Run the script
ssupdate.sql
atthe consolidated database to upgrade the
SQLRemote system tables and procedures.
The
ssupdate.sql
scriptis held in your Sybase directory.
4. Run the script
squpdate.sql
atthe stable queue database to upgrade the
SQLRemote stable queue tables and procedures.
The
squpdate.sql
scriptis held in your Sybase directory.
Thesoftware is now upgraded.
25