Lifecycle Management for Data-tier Applications

Important

To create and manage databases using the latest version of Data Tier Applications (DACPAC), install the most recent release of SQL Server Data Tools from Get Started with Microsoft SQL Server Data Tools.

Data-tier Application (DAC) projects leverage the functionality of the other SQL Server database project types in Visual Studio. Developers using Visual Studio Team System can use the general lifecycle management features available in that environment, such as source code control, schema compare, and static code analysis.

Visual Studio Team System Lifecycle Management

The following table lists the topics describing the lifecycle management features of database projects that also apply to DAC projects.

Common tasks

Supporting content

Convert between DAC and database projects

Put a DAC project under version control

Refactoring DAC code

Reduce the effort required and the probability of error when making changes, such as name changes, that affect many objects in a project.

Compare schemas

You can compare the schemas generated by two DAC projects, or between a DAC project and a database project.

Perform static analysis of DAC code

Perform unit testing

See Also

Concepts

Creating Data-tier Application Projects

Configuring the Server Selection Policy

Adding New Objects to Data-tier Applications

Building Data-tier Application Projects

Deploying Data-tier Application Packages