Upgrading Databases Using Dump and Load

When you upgrade SAP ASE, you can also upgrade databases and transaction logs from versions of SAP ASE 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.