Upgrading an Adaptive Server User Database with rs_init

If you use rs_init to upgrade Replication Server and the RSSD or ERSSD, you must apply upgrades to a primary, replicate, or standby database in the replication system to accommodate changes, such as installing new stored procedures, that support the new version of Replication Server to which you are upgrading, and features such as Multi-Path Replication™.

If you do not apply the upgrades to replicate databases such as:
  • Adaptive Server – you cannot use Multi-Path Replication for replication to Adaptive Server databases after you upgrade Replication Server to 15.7 and later.
  • Sybase IQ – Replication Server suspends replicate connections to the Sybase IQ replicates after you upgraded Replication Server to version 15.7.1 or later, and you see a "Awaiting Upgr" status if you use admin who.
  1. Start rs_init.
  2. Select Upgrade an existing database in the replication system from the Configure Replication System window, then choose Continue.
  3. Enter the information from the “Database Setup Worksheet” for the upgraded Replication Server:
    • Name of the Adaptive Server that manages the database you are upgrading.
    • Name of the database you are upgrading.
    • Login name for the “sa” user on the Adaptive Server that manages the database that you are upgrading. The default value is “sa.”
    • Adaptive Server “sa” user password.
    • Login name for the maintenance user on the Adaptive Server that manages the database that you are upgrading. The default is “database_maint,” where “database” is the name of the database you are upgrading.
  4. Select Continue. rs_init performs the upgrade.
  5. If you have more Replication Servers or databases to upgrade, repeat the procedures to stop Replication Agent and quiesce Replication Server, upgrade RSSD or ERSSD, and upgrade Adaptive Server databases.