Downgrading to an earlier version

This section discusses how to downgrade from a 12.5.0.3 version of Adaptive Server with the multiple temporary database feature enabled to Adaptive Server version 12.5.0.2.

NoteVersions earlier than 12.5.0.2 are not supported for downgrading from version 12.5.0.3.

StepsDowngrading from a multiple tempdb-enabled Adaptive Server

  1. Use sp_tempdb to remove all bindings.

  2. Drop all user-created temporary databases.

  3. Shut down the server.

  4. Start version 12.5.0.2 of Adaptive Server.

  5. Use the installmaster and instmsgs.ebf that were part of Adaptive Server version 12.5.0.2 to reinstall the system stored procedures and messages.

    Adaptive Server version 12.5.0.2 requires no additional steps to support downgrading from version 12.5.0.3.

    Version 12.5.0.2 was modified to support dynamically redefining trees from text if they had been normalized using user-created temporary databases in version 12.5.0.3.