When you upgrade an Adaptive Server installation is upgraded to a new version, all databases associated with that server are automatically upgraded.
As a result, database and transaction log dumps created with a previous version of Adaptive Server must be upgraded before they can be used with the current version of Adaptive Server.
Adaptive Server provides an automatic upgrade mechanism – on a per-database basis – for upgrading a database or transaction log made with Backup Sever to the current Adaptive Server version, thus making the dump compatible for use. This mechanism is entirely internal to Adaptive Server, and requires no external programs. It provides the flexibility of upgrading individual dumps as needed.
The following tasks are not supported by this automatic upgrade functionality:
Loading an older release of the master database. That is, if you upgraded Adaptive Server to the current version, you cannot load a dump of the master database from which you upgraded.
Installing new or modified stored procedures. Continue to use installmaster.
Loading and upgrading dumps generated previous to SQL Server release 10.0.
