sp_downgrade

Description

Validates readiness for downgrade to an earlier 15.0.x release. Also downgrades the system catalog changes Adaptive Server 15.0.2 modified.

Syntax

sp_downgrade @cmd = {'prepare' | 'downgrade' | 'help',}
	@toversion = 'n'[, @verbose = 0 | 1][, @override = 0 | 1]

Parameters

prepare: is use first to validate readiness of Adaptive Server 15.0.2 for downgrade.

downgrade: is used after prepare parameter when ready to proceed with the act of downgrading to a previously installed 15.x version of Adaptive Server. Server must be in single user mode. (started with -m option)

toversion: can be 15.0 or 15.0.1 written “150” or “15.0”, “1501” or “15.0.1”

verbose: specifies verbosity. Valid options are 0 (for no) or 1 (for yes).

override: specifies whether to skip databases that are not writable at this time. Valid options are 0 (for no) or 1 (for yes).

Examples

Example 1

This is an example of the output from running sp_downgrade.

00:00000:00006:2007/04/25 17:39:29.63 server  Starting downgrading ASE.
00:00000:00006:2007/04/25 17:39:29.64 server  Downgrade : Downgrading login
passwords.
00:00000:00006:2007/04/25 17:39:29.64 server  Downgrade : Starting password 
downgrade.
00:00000:00006:2007/04/25 17:39:29.64 server  Downgrade : Removed sysattributes rows.
00:00000:00006:2007/04/25 17:39:29.64 server  Downgrade : Updated 0 passwords.
00:00000:00006:2007/04/25 17:39:29.65 server  Downgrade : Removed columns in 
syslogins - lastlogindate, crdate, locksuid, lock reason, lockdate are removed.
00:00000:00006:2007/04/25 17:39:29.65 server  Downgrade : Truncated password lengths.
00:00000:00006:2007/04/25 17:39:29.65 server  Downgrade : Successfully completed 
password downgrade.
00:00000:00006:2007/04/25 17:39:29.65 server  Downgrade : Marking stored procedures 
for recompilation.
00:00000:00006:2007/04/25 17:39:31.31 server  Downgrade : Dropping Sysoptions system 
table.
00:00000:00006:2007/04/25 17:39:31.33 server  Downgrade : Setting master database 
minor upgrade version.
00:00000:00006:2007/04/25 17:39:31.33 server  Downgrade : Setting user databases minor upgrade version.

Usage

Use to revert to the previously installed Adaptive Server 15.0.x release. At this time it is not possible to revert to Adaptive Server 15.0.2.