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.

Put a database (@db_name) in single-user mode.
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.
Use dump database @db_name to dump the database.
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.
Take the @db_name database out of single-user mode.