Adaptive Server Downgrades

An Adaptive Server that has been upgraded to 15.7 SP100 requires specifics tasks before it can be downgraded.

Even if you have not used any of the new features in Adaptive Server 15.7 or later, the upgrade process added 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 SP100
  Use sp_downgrade to downgrade Adaptive Server 15.7 SP100 to an earlier version.
• Downgrading to an Earlier Version of Adaptive Server 15.7
  Use sp_downgrade_esd to downgrade your installation of Adaptive Server 15.7 SP100 to Adaptive Server 15.7 or an ESD version of 15.7.
• Opening a 15.7 SP100 Database in an Earlier 15.7 Version of Adaptive Server
  You can open an Adaptive Server 15.7 SP100 database in an earlier 15.7 Adaptive Server by using the sp_downgrade_esd system procedure.
• Additional Considerations for New Features Used
  Additional downgrade steps may be necessary due to Adaptive Server 15.7 or later features that are unavailable in the Adaptive Server version to which you are downgrading.
• Performing an In-Place Downgrade
  Downgrade Adaptive Server 15.7 SP100 to versions 15.5, 15.5 ESDs, 15.7, and 15.7 ESDs in place using the same installation directory the upgrade was performed from.
• Downgrading Job Scheduler
  If you are downgrading to Adaptive Server versions 15.0.1 Cluster Edition, 15.0.1 Cluster Edition ESD, or 15.0.3 Cluster Edition, run installjsdb script from the earlier version.
• Post-downgrade Tasks for Adaptive Server
  After you perform the basic downgrade steps, finish the process by handling residual tasks.