When a SQL Server installation is upgraded to a new release, all databases associated with that server are automatically upgraded.
As a result, the database and transaction log dumps created with any previous SQL Server must be upgraded before they can be used with the current SQL Server.
SQL Server release 11.0 provides an automatic upgrade mechanism, on a per-database basis, for upgrading a database or transaction log dump from any SQL Server release 10.0 to the current SQL Server, thus making the dump compatible for use. This mechanism is entirely internal to SQL Server release 11.0 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 a SQL Server release 10.0 master database onto release 11.0.
Installing new or modified stored procedures. Continue to use installmaster.
Loading and upgrading dumps prior to SQL Server release 10.0.
Associated with this feature is a new online database command. This command marks a database available for public use after a normal load sequence, and if needed, upgrades a loaded database and/or transaction log dumps to the current version of SQL Server.
For more information on upgrading database dumps, see Chapter 21, “Backing Up and Restoring User Databases,” in the System Administration Guide and the load database and dump database commands in the Reference Manual.
For more information on the online database command, see the Reference Manual.
