Using Sqlupgrade

sqlupgrade verifies that the server is eligible for the upgrade. Perform all pre-upgrade tasks before running sqlupgrade.

1. Make sure your old server is running.
2. Verify that you have performed the tasks mentioned on the window, before beginning the upgrade.
3. Source SYBASE.csh before running sqlupgrade if you have not already done that.
4. 
   
   Execute sqlupgrade, by entering at the UNIX prompt:

   $SYBASE/$SYBASE_ASE/bin/sqlupgrade

   A sqlupgrade window now displays.

5. The first screen warns you to back up the databases, devices, and so on. Click Next to proceed to the next screen.
6. Click OK.
7. The Next screen prompts you to enter the old Sybase directory, and the old Adaptive Server directory.
8. Click OK. The Adaptive Server Selection window displays.
9. From the list of server names provided, select the server you want to upgrade.

   If the server you are upgrading is not running, sqlupgrade prompts you to start the server. The server you are upgrading must be running.

10. Click OK. The SA Password window is displayed.
11. Enter the password for the System Administrator (sa) login.
12. Click OK. The Specifying Upgrade Options window is displayed.
13. Specify an upgrade option.

    The upgrade eligibility tests verify that your current server meets the requirements for upgrading to the new version. (The online help provides a partial list of what the upgrade eligibility tests check.) If your current server fails the upgrade eligibility test, you must fix the problem.

14. Click OK to upgrade your server.

    sqlupgrade displays the Status Output window. View the Status Output window for the completion status and informational messages about the upgrade process.

    Warning!  

    Do not interrupt the upgrade, and do not try to connect to Adaptive Server or run any stored procedures while the upgrade is in progress.

    You can also check the progress of the upgrade by viewing the sqlupgrade log in $SYBASE/$SYBASE_ASE/init/logs/sqlupgradeMMDD.NNN MM is the month, DD is the date, and NNN is a three-digit number identifying the srvbuild session.

    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 internally runs the upgrade binary to perform the upgrade.

    If the upgrade is successful, a “Done” message is displayed in the Status Output window.

15. The upgrade process:
    
    

    • Creates the RUN_servername file

    • Runs the installmaster script

16. Check that the upgrade has been successful by logging in to the server and checking select @@version to confirm that it is at 15.5. Also, sp_configure “upgrade version” should return 15000.
17. For information about compiled objects, see Troubleshooting.