Microsoft SQL Server 2008 R2 810-08230 User Manual

Product codes

810-08230

Upgrading a Data-Tier Application

CHAPTER 3

NOTE

If the database has changed, it is a best practice to review the potential data

losses before you proceed and verify that this is the outcome you want for the upgrad-
ed database. However, the original database is still preserved, renamed, and maintained
on the SQL Server instance. Any data changes can be migrated from the original data-
base to the new database after the upgrade is complete.

The next page includes a summary of the settings that will be used to upgrade the

data-tier application . Review the information displayed in the Summary page and the
DAC properties tree to ensure that the actions to be taken are correct, and then click
Next to continue .

The Upgrade DAC page, shown in Figure 3-12, includes results, such as the success

or failure of each action performed during the upgrade process . Some of the actions
tested include

■

Validating the upgrade .

■

Preparing system tables in msdb .

■

Preparing the deployment script .

■

Creating the new database .

■

Creating schema objects in the database .

■

Setting the source database as read-only .

■

Disconnecting users from the existing source database .

■

Preparing scripts to copy data from the database .

■

Disabling constraints on the database .

■

Setting the database to read/write .

■

Renaming the database .

■

Upgrading the DAC metadata in msdb to reflect the new DAC version.

Review the result for every action . You can also click Save Report to capture the entire
report . Then click Finish to complete the upgrade .