Updated: July 9, 2020 (November 15, 2010)

Data-tier Applications Upgrade Wizard Confirmation

Wes Miller analyzes and writes about Microsoft’s security, identity management, and systems management technologies. Before joining Directions on Microsoft, Wes... more

An Upgrade Wizard can update deployed Data-tier Applications (DACs). The DAC feature of SQL Server 2008 R2 packages database schema elements and automatically generates scripts to deploy and update them. Shown here is the DAC Upgrade Wizard’s confirmation screen, which provides an overview of the process of updating a DAC.

For an update, SQL Server performs the following tasks:

Checks permissions and ensures the application name in the DAC package matches the application that is already registered
As with a new deployment, a new database is created with the specified database objects and the necessary SQL Server logins are created. This database is named with a random string in order to avoid a name collision with the original database
Sets the original database to read-only mode and terminates user connections to it
Generates scripts to copy data into the new database from the original one and begins copying
Renames the original database to a value containing its

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now