Home

Overview

This page contains basic information about the DacFX API of SQL Server 2014

Read the page below to get an introduction to DAC files, what they are, and how they relate to the rest of the world. The page is particularly interesting to understand the definition of DACPAC and BACPAC files.

https://technet.microsoft.com/en-us/library/ee210546.aspx

Workflows to generate a DAC file

Create a dacpac file with SQL Server Management Studio

http://sqlblog.com/blogs/jamie_thomson/archive/2014/01/18/dacpac-braindump.aspx

A SQL Server project in Visual Studio Express/Community

Follow the guide below to create a SQL Server project and compile the project to obtain a dac file.

http://www.mssqltips.com/sqlservertip/2971/creating-a-visual-studio-database-project-for-an-existing-sql-server-database/

You might need to update SSDT as described here (for setup with VS 3013 Community and SQL Server 2008 R2) if encounter a build error on compilation of the SQL Server project:

http://stackoverflow.com/questions/25774471/vs2013-database-project-fails-to-build

Use SqlPackage.exe to export, import, or publish incrementally a dacpac file on/off an SQL Server

https://msdn.microsoft.com/en-US/library/hh550080%28v=vs.103%29.aspx

Loading a model in C# from a dacpac file (SQL Server Data Tools Team Blog):

http://blogs.msdn.com/b/ssdt/archive/2013/12/23/dacfx-public-model-tutorial.aspx