Pre-upgrade tasks

NoteBefore you begin the upgrade process, install Adaptive Server 12.5.x onto your system. See Chapter 2, “Installing Adaptive Server.” Also, see “Special Upgrade Instructions” in the release bulletin.

To ensure a successful upgrade, review the following pre-upgrade tasks and perform them as necessary. Depending on the old server configuration, you may not need to perform all pre-upgrade tasks.

  1. Check system and upgrade requirements.

  2. Check RUN_server file location.

  3. If you are upgrading Adaptive Server, the previously installed version of the server must be running. If you are upgrading Backup Server, Historical Server, Monitor Server, or XP Server, those servers must not be running.

  4. Procedure text is required for upgrade.

  5. Reserved words.

  6. Using quoted identifiers.

  7. Verify that users are logged off.

  8. Check database integrity.

  9. Back up databases.

  10. Dump transaction log.

  11. Make sure that master is the default database for the “sa” user.

  12. Prepare the database and devices for upgrade.

  13. Create a sybsystemdb database.

    NoteIf you are upgrading from Adaptive Server Enterprise from 11.9.x or earlier, you must create the sybsystempdb.

  14. Disable auditing.

  15. Disable disk mirroring.

  16. Verify that your SYBASE environment variable points to the location of the new Adaptive Server software files you just unloaded.

    You also can set the OLDSYBASE environment variable to the location of the server you are upgrading, to avoid having to type this path when you run sqlupgrade.

  17. Copy the following files from earlier versions of Adaptive Server to their corresponding Adaptive Server 12.5.x installation:

    For UNIX platforms:

    For Windows platforms: