Installation guide

Dumping a 15.7 ESD #2 Database to Load into a 15.7 or 15.7
ESD #1 Adaptive Server
Using sp_downgrade_esd on an Adaptive Server 15.7 ESD #2 database allows you to load it
into Adaptive Server 15.7 or 15.7 ESD #1.
Prerequisites
To use sp_downgrade_esd, you must have sa_role, and be in the master database.
Task
If you have a database in Adaptive Server version 15.7 ESD #2 that you want to open in
Adaptive Server 15.7 or 15.7 ESD #1, you can downgrade it with sp_downgrade_esd
temporarily to perform the dump and load, after which you revert the database so that it is
usable in the current version of Adaptive Server again.
Perform these one database at a time, and only for the databases you want to open in an earlier
version of Adaptive Server 15.7.
1.
Put a database (
@db_name ) in single-user mode.
2.
Run sp_downgrade_esd @db_name on the database.
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:
• "1" – 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.
3.
Use dump database @db_name to dump the database.
4.
Run online database @db_name . This brings the affected database back to its proper
revision level of 15.7 ESD #2 after the downgrade procedure.
5.
Take the @db_name database out of single-user mode.
See also
• Downgrading to an Earlier Version of Adaptive Server 15.7 on page 108
CHAPTER 11: Adaptive Server Downgrades
110 Adaptive Server Enterprise