Upgrading to Replication Server 12.6

This section describes how to upgrade to Replication Server 12.6, first by upgrading your RSM Servers, and then upgrading your Replication Servers. You must upgrade the RSM Servers if you are maintaining a mixed-version replication system. See “Mixed-version replication systems” for more information.

Sybase recommends that you upgrade RSM Servers before you upgrade Replication Servers. To upgrade routes for mixed-version support, you need the latest RSM Servers.

Upgrading from RSM version 12.5 and later to RSM 12.6

If you have a version of RSM that is earlier than 12.5, you must first upgrade RSM to version 12.5 to perform these steps.

Make backup copies of the RSM Server configuration files and scripts\rsmxxxx.sql files, in case you need to downgrade in the future.

Update the configuration files, then update the RUN file. See “Upgrading from RSM version 11.5.x”.

Start a new RSM Server.

A message in the log prompts that the RSSD procedures need to be upgraded; the RSM Server stays up.

Issue the command to load new RSSD procedures through the RSM Client, or through the RSM Server command if you are scripting multiple upgrades.

Upgrading to Replication Server 12.6 from an earlier version

Back up your current installation.

If you plan to install the Replication Server software in a directory other than an existing Sybase version directory, make sure that the interfaces file is accessible. See Replication Server Installation Guide for instructions.

Install the new Replication Server software from media. See Replication Server Installation Guide for instructions.

Upgrade the RSSD for each Replication Server. See “Upgrading an RSSD”.

Upgrade each user database that is managed by an upgraded Replication Server. See “Upgrading a user database in a replication system”.

Upgrade RepAgents for Adaptive Server 12.6 databases. See “Upgrading RepAgent threads in Adaptive Server databases”.

Upgrading an RSSD

Complete these steps in the order shown in this section to upgrade an RSSD based on the information from the “Replication Server Installation Worksheet” for the Replication Server you are upgrading. Upgrading an RSSD may add new Replication Server system tables, add new rows or columns to existing tables, or install new stored procedures.

To upgrade RSSD procedures from Sybase Central, select the Replication Server icon, then choose File | Upgrade RSSD Procedures. See the Sybase Central online help for further instructions.

Verify that the Adaptive Servers with RSSDs, Replication Servers, and RepAgent that you are upgrading are running.

Enter the name of the Replication Server with the RSSD you are upgrading.

Select Configure a Server Product.

Select Replication Server.

Then choose Continue.

Select Upgrade an Existing Replication Server.

Then choose Continue.

Complete the Upgrade Existing Replication Server screen with the information from the “Replication Server Installation Worksheet” for the Replication Server you are upgrading.

Enter the name of the Replication Server with the RSSD you are upgrading.
Enter the login name for the RS SA user. The default value is “sa.”
Enter the password for the “sa” user on the Replication Server.
Enter the name of the Adaptive Server or SQL Server that contains the RSSD for the Replication Server.
Enter the name of the RSSD.
Enter the login name for the “sa” user on the system Adaptive Server or SQL Server. The default value is “sa.”
Enter the Adaptive Server or SQL Server “sa” user password.
Select No if the RSSD has a RepAgent. Select Yes only if the RSSD has an LTM. If you select Yes, and it is an Adaptive Server or SQL Server database:
- Enter the name of the RSSD LTM.
- Enter the login name of the LTM system administrator.
- Enter the password for the LTM system administrator. Press Ctrl+A to save your changes. rs_init displays the message:
```
Execute the Replication Server tasks now?
```

Choose Continue to continue the RSSD upgrade.

If the Replication Server is running, rs_init shuts it down.

rs_init displays informational messages as it loads the upgrade script into the RSSD. When the upgrade is complete, rs_init displays these messages:

RSSD successfully upgraded from old_rel_no to new_rel_no. Replication Server 'rs_name' can now be restarted. Task to upgrade the RSSD succeeded. Configuration completed successfully.

where:

old_rel_no – is the Replication Server version from which you are upgrading.
new_rel_no – is Replication Server version 12.6.
rs_name – is the name of the Replication Server.

Press Return after each message. You see the Configure Replication System screen.

Select OK. You see the message “Replication server ‘name’ can now be restarted.”

Select OK. You see the RS_Init window.

Select OK. You see the message “Configuration completed successfully.”

If you have more Replication Servers to upgrade, go back to “Upgrading to Replication Server 12.6” and repeat the procedure.

If you installed the new Replication Server software in a different directory from the previous version, modify the runserver files for the Replication Servers and LTMs so that they use the programs in the new version directory.

Restart the Replication Server, and the LTMs that are associated with it, using the appropriate executables for the new version.

For instructions on downgrading an RSSD to an earlier version, see “Downgrading to an earlier version”.