Special considerations exist for downgrading Adaptive Server version 15.7 that uses replicated databases,
If SQL replication has been enabled on the server you are
downgrading from and the server has replicated databases, you must follow different
procedures that depend on 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.
- You are not using RepAgent – consult the specific documentation for the product
you are using to replicate data.
- You downgrade to a version earlier than 15.0.2 ESD #3 – SAP 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:
- Suspend transaction processing and replication activities.
- Drain the transaction logs for primary databases.
- Disable the secondary truncation point.