Downgrading Adaptive Server with Replicated Databases

When downgrading an Adaptive Server 15.5 that has replication enabled on databases, you must complete additional steps before starting the downgrade procedure.

If the server you are downgrading from has replicated databases and SQL replication has been enabled you must follow different procedures depending upon the version of Adaptive Server you are downgrading to.

If your replication system is using RepAgent and you are downgrading to a 15.0.2 ESD #3 or higher there are no additional steps required. Adaptive Server 15.0.2 ESD #3 can keep the data synchronized.

If you are not using RepAgent to replicate data, consult the specific documentation for the product you are using.

If you downgrade to a version lower than 15.0.2 ESD #3, Sybase recommends that you use the standard documented procedure to downgrade an Adaptive Server with replicated databases.

The standard procedure to downgrade Adaptive Server with replicated databases consist of ensuring that all replicated data in the primary database transaction log has been successfully transferred to the standby or replicate database. Once RepAgent is started again after the downgrade process, you must ensure that it does not read logs written with version 15.5.

  1. Suspend transaction processing and replication activities
  2. Drain the transaction logs for primary databases
  3. Disable the secondary truncation point.

See the Upgrading Servers with Replicated Databases topic, for more detailed information.