Upgrading the Server

Learn how to upgrade the server here.

1. If you are upgrading from Adaptive Server 12.5.4, run syconfig.exe, and choose:
   1. Configure Adaptive Server > the server name > logon > Command line
      
   2. Add -T7841 If you are upgrading from version 12.5.4 to version 15.5 ESD #1 under the IPv4 environment, this option is not necessary.
   3. Save the changes.
2. If you are upgrading from Adaptive Server 12.5:

   set OLDSYBASE=<old_$SYBASE_directory>
   set OLDSYBASE_ASE=ASE-12_5

   This is required if you are using sybatch.exe to perform your upgrade. Install the new Adaptive Server into the same directory as the Adaptive Server you are upgrading.
3. Run Start > Programs > Sybase > Adaptive Server Enterprise > Server Config.
   
4. Click Upgrade Adaptive Server in the Configure Sybase Servers window.
5. Enter the name of the old Sybase directory. Enter the name of the old Adaptive Server directory, such as ASE-12_5. Enter the old OpenClient Server directory such as OCS-12_5.
6. Click Continue.
7. In the Existing Servers window, select the Adaptive Server to upgrade and choose Continue.
8. In the Password window, enter the administrator login name and password.
9. Click Continue.
10. If Adaptive Server is not running, the upgrade program starts it for you automatically.

    Before making any changes to the existing Adaptive Server databases, the installer states: You are advised to back up your databases before upgrading. Do you want to proceed with the upgrade?

11. If you have not backed up the existing databases, choose No in the Upgrade window and use the dump database command to make backup copies.

    If you have made the necessary backups, select

    Yes. Server Config begins the database eligibility test.

    After all pre-upgrade checks are successful, the old server is shut down and the new Adaptive Server dataserver binary is started on the old master device. sqlupgrade or the Server Config utility internally runs the upgrade binary to perform the upgrade.

    Note:

    If the upgrade was successful, back up all the databases, including the master database, in your upgraded Adaptive Server.

    To check the upgrade, use the Windows Notepad to view the log file in %SYBASE%\%SYBASE_ASE%\upgrade\errorlog.upg.

    Log information can also be found by viewing the log file in %SYBASE\%SYBASE_ASE%\init\logs\