Adaptive Server Downgrades

An Adaptive Server that has been upgraded to 15.7 requires specifics tasks before it can be downgraded, due to the introduction of new features.

Even if you have not used any of the new features in Adaptive Server 15.7, the upgraded server adds columns to system tables. This means you must use sp_downgrade to perform the downgrade.

The sp_downgrade procedure requires sybase_ts_ role, and you must have sa_role or sso_role permissions. See sp_downgrade in Reference Manual: Procedures.

There are additional steps to perform if you are using encryption or replicated databases.

• Preparing to Downgrade Adaptive Server
  Prepare your system before starting the downgrade.
• Downgrading from Adaptive Server 15.7
  Use sp_downgrade to downgrade Adaptive Server 15.7 to an earlier version.
• Additional Considerations for New Features Used
  Additional downgrade steps may be necessary due to Adaptive Server 15.7 features that are not available in the Adaptive Server version to which you are downgrading.
• Restoring Original Messages After a Downgrade
  You can restore the original messages for the earlier version of Adaptive Server after you perform a downgrade.
• Downgrading Job Scheduler
  If you are downgrading to Adaptive Server versions 15.0 or 15.0.1, run installjsdb script from the earlier version.
• Downgrading an Adaptive Server that Uses Encryption
  Perform these steps to downgrade an Adaptive Server versions 15.7 and later if you enabled 256-bit key encryption keys.
• Downgrade Considerations for Adaptive Server with Replicated Databases
  Special considerations exist for downgrading Adaptive Server version 15.7 that uses replicated databases,
• Post-Downgrade Tasks for Adaptive Server
  After you perform the basic downgrade steps, finish the process by handling residual tasks.