Opening a 15.7 SP100 Database in an Earlier 15.7 Version of Adaptive Server

You can open an Adaptive Server 15.7 SP100 database in an earlier 15.7 Adaptive Server by using the sp_downgrade_esd system procedure.

If you have a database in Adaptive Server version 15.7 SP100 that you want to open in Adaptive Server 15.7, 15.7 ESD #1, ESD #2, or ESD #3, or ESD #4, you can downgrade it with sp_downgrade_esd and perform the dump and load. You can then revert the database so that it is usable in the current version of Adaptive Server again.

Note: Use these steps only to open a 15.7 SP100 database in an earlier 15.7 version of Adaptive Server, and not to downgrade Adaptive Server itself.

Perform these steps for 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:
  - "ESDx" – for an ESD version of Adaptive Server version, where x is the ESD number, such as 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 after the downgrade procedure.
Take the @db_name database out of single-user mode.