Installation guide

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.
Post-Downgrade Tasks for Adaptive Server
After you perform the basic downgrade steps, finish the process by handling residual tasks.
1.
Installing system stored procedures over the old version drops auditing information about
system stored procedures. Use the output of sp_displayaudit recorded during
predowngrade to help determine the system stored procedures for which auditing was
enabled. Reenter the audit options using sp_audit. For example, if sp_addlogin was
audited in your server before upgrading, run this command to reenable auditing on
sp_addlogin:
sp_audit "exec_procedure", "all", "sp_addlogin", "on"
After you run installmaster, installmodel, installcommit,
installsecurity, installhasvss, installjsdb, and installmsgsvss
on your downgraded server, return system stored procedures to their earlier form. New
CHAPTER 11: Adaptive Server Downgrades
114 Adaptive Server Enterprise