Export (0) Print
Expand All

Creating Data-tier Application Projects

Visual Studio 2010
Important note 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.

A data-tier application (DAC) project is used to manage the development of the SQL Server objects used by an application. Use the New project dialog box to select the Data-tier Application project type. After the project is created, set the project properties.

The structure and behavior of the DAC project is modeled on the SQL Server database projects. DAC project files share the same file extension as database projects: .dbproj.

There is no wizard for creating data-tier application projects. In the New project dialog box, select the Data-tier Application project template and specify the project name. Visual Studio creates a DAC project with that name and you then edit the project properties to configure the behaviors of the project. After the project has been created and the properties set, you can add objects to the project, build the project into a DAC package, and deploy the DAC package to an instance of the SQL Server Database Engine.

For more information on the steps for creating a project and editing the properties, see How to: Create a Data-tier Application Project.

For more information about the data-tier application project properties, see Data-tier Application Project Properties.

You can also convert a database project to a DAC project, or convert a DAC project to a database project. For more information, see Converting Between Data-tier Application Projects and Database Projects.

Community Additions

ADD
Show:
© 2014 Microsoft