Installation guide

3.
Perform the upgrade steps as prompted.
See also
• Upgrade to Adaptive Server 15.7 ESD #2 on page 83
Upgrading Databases Using Dump and Load
When you upgrade Adaptive Server, you can also upgrade databases and transaction logs from
versions of Adaptive Server as early as 12.5 using the dump and load commands.
Some issues of which you should be aware:
• The upgrade process requires space for copying data and logging changes to the system
tables. If the source database in the dump was full, the upgrade process might fail. You can
use alter database to extend the free space in the event of insufficient-space errors.
• After reloading an older dump, run sp_checkreswords from the new installation on the
loaded database to check for reserved words.
How Compiled Objects Are Handled When Upgrading Adaptive Server
Adaptive Server upgrades compiled objects based on their source text.
Compiled objects include:
• Check constraints
• Defaults
• Rules
• Stored procedures (including extended stored procedures)
• Triggers
• Views
The source text for each compiled object is stored in the syscomments table, unless it has
been manually deleted. The upgrade process verifies the existence of the source text in
syscomments. However, compiled objects are not actually upgraded until they are invoked.
For example, if you have a user-defined stored procedure named list_proc, the presence of its
source text is verified when you upgrade. The first time list_proc is invoked after the upgrade,
Adaptive Server detects that the list_proc compiled object has not been upgraded. Adaptive
Server recompiles list_proc, based on the source text in syscomments. The newly compiled
object is then executed.
Upgraded objects retain the same object ID and permissions.
You do not receive any notification if the compiled objects in your database dump are missing
source text. After loading a database dump, run sp_checksource to verify the existence of the
source text for all compiled objects in the database. Then, you can allow the compiled objects
to be upgraded as they are executed, or you can run dbcc upgrade_object to find potential
problems and upgrade objects manually.
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 101