Downgrade Considerations for Adaptive Server with Replicated Databases

Special considerations exist for downgrading Adaptive Server version 15.7 that uses replicated databases,

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 later, there are no additional steps required. Adaptive Server 15.0.2 ESD #3 can keep the data synchronized.

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

If you downgrade to a version earlier 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 consists 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.7:
  1. Suspend transaction processing and replication activities.
  2. Drain the transaction logs for primary databases.
  3. Disable the secondary truncation point.
Parent topic: Adaptive Server Downgrades