sp_downgrade prepares your system for downgrade to a previous 15.0.x version. See Chapter 6, "Downgrading from Adaptive Server 15.0.2" in the Installation Guide for more information.
The examples in this section illustrate how sp_downgrade output applies to encrypted functionality used in Adaptive Server version 15.0.2. It associates the sp_downgrade output with the necessary downgrade actions, which are listed in “Downgrading from Adaptive Server 15.0.2 to 15.0 GA or 15.0 ESD #1” and “Downgrading from 15.0.2 Adaptive Server to 15.0 ESD#2 or later”.
You must run sp_downgrade twice: the first time to check if your system is ready for downgrade and the second time to make changes so that your system can be used with Adaptive Servers earlier than 15.0.2. The syntax is:
sp_downgrade 'prepare' | 'downgrade' | 'help' , 'version_number'
where version_number must be
either 15.0 or 15.0.1.
If you are downgrading to:
15.0 GA or 15.0 ESD #1, enter “15.0”. For example:
sp_downgrade 'prepare', '15.0'
15.0 ESD #2 or later, enter “15.0.1”. For example:
sp_downgrade 'prepare', '15.0.1'
