If you are performing a major upgrade from an Adaptive Server version earlier than 15.x, run the preupgrade utility. You must have system administrator privileges to perform an upgrade.
If your server is at a 15.x level, do not use the sqlupgrade or sqlupgraderes upgrade utilities.
Each new server version contains features that introduce parameters, commands, reserved words, and so on. The preupgrade utility prepares the old server by making sure all necessary directories and settings are correct for the upgrade. When running the preupgrade utility, manually stop and start the server. You need not start the server before running the sqlupgrade upgrade utility; the utility starts the server when needed.
Manually drop objects before you execute procedures for the first time. The first time you run the server after an upgrade, the server internally rebuilds procedures from the text in syscomments. The procedure may not execute properly if it contains code that drops, then re-creates, an existing object.