Note: If you are downgrading the entire installation, perform
sp_downgrade_esd on all of your non-temporary databases,
then downgrade the master database last.
The syntax for
sp_downgrade_esd is:
sp_downgrade_esd @db_name [, @esd [, @verbose]]
where:
- @db_name – is the name of the database you are
downgrading
- @esd – is the ESD number you are
downgrading to. The valid options are:
- "ESD1" – for Adaptive Server version 15.7 ESD
#1.
- "GA" – for Adaptive
Server version 15.7.
- @verbose – when used, displays the output in the verbose
mode.
For example:
1> sp_downgrade_esd tempdb, esd1
2> go
Reverting database 'tempdb' to 'ESD1'.
Database 'tempdb' is now suitable for use by ESD1.
(return status = 0)
1> sp_downgrade_esd sybsystemprocs, esd1
2> go
Reverting database 'sybsystemprocs' to 'ESD1'.
Database 'sybsystemprocs' is now suitable for use by ESD1.
(return status = 0)
1>
2> sp_downgrade_esd sybsystemdb, esd1
3> go
Reverting database 'sybsystemdb' to 'ESD1'.
Database 'sybsystemdb' is now suitable for use by ESD1.
(return status = 0)
1> sp_downgrade_esd model, esd1
2> go
Reverting database 'model' to 'ESD1'.
Database 'model' is now suitable for use by ESD1.
(return status = 0)
1> sp_downgrade_esd MYASE_tdb_1, esd1
2> go
Reverting database 'MYASE_tdb_1' to 'ESD1'.
Database 'LUMINOUS_tdb_1' is now suitable for use by ESD1.
(return status = 0)
1> sp_downgrade_esd master, esd1
2> go
Reverting database 'master' to 'ESD1'.
Database 'master' is now suitable for use by ESD1.
(return status = 0)
1> shutdown
2> go