Upgrading SQL Remote

SQL Remote installations include a consolidated database and many remote databases, together with a SQL Remote Message Agent at each site.

At each site, the SQL Remote Message Agent handles the sending and receiving of messages. The messages take the form of SQL statements, and the database server handles the actual execution of those SQL statements.

The upgrade requirements for SQL Remote are as follows:

Software upgrades can be one site at a time Older Message Agents (dbremote) can exchange messages with version 12 Message Agents. For version 5 of SQL Remote, the version 5 Message Agents can exchange messages with version 12 Message Agents, as long as the compression database option is set to a value of -1. There is no need to upgrade software throughout the installation simultaneously. See compression option [SQL Remote].
Upgrade databases If you are upgrading a remote or consolidated database that used SQL Anywhere version 9 or lower, you must upgrade the database file format by unloading and reloading your database. There is no need for all databases to be upgraded at the same time.
For instructions on unloading and reloading the database, see Rebuilding version 9 and earlier databases for version 12.
Upgrading Adaptive Server Enterprise consolidated databases SQL Remote no longer supports Adaptive Server Enterprise consolidated databases. To synchronize Adaptive Server Enterprise databases, you should upgrade to MobiLink.
For information about migrating from SQL Remote to MobiLink, see http://www.sybase.com/detail?id=1034174#335.
Upgrading with SQL Remote Support for the VIM and MAPI message systems for SQL Remote was removed in version 11.0.0. When you upgrade a database that uses VIM or MAPI to SQL Anywhere version 12, you must change the message type to File, FTP, or SMTP. If the message type is MAPI or VIM, dbremote.exe does not start.

Example

One approach to upgrading version 5 of SQL Remote is as follows:

Upgrade the consolidated database server and SQL Remote Message Agent, and then upgrade the database file by unloading and reloading the consolidated database. Set the compression database option to -1, so that all messages are compatible with the version 5 software at remote sites. To unload and reload the consolidated database, see Rebuild databases involved in synchronization or replication.
One at a time, upgrade the remote database servers and Message Agents, and then upgrade the database file format by unloading and reloading the remote databases. You can set the compression database option to a value other than -1 to take advantage of compression and encoding on messages being sent to the consolidated database server. To unload and reload the remote databases, see Rebuild databases involved in synchronization or replication..
When all remote database servers and Message Agents are upgraded, set the compression database option at the consolidated site to a value other than -1.

Discuss this page in DocCommentXchange.