title: How to include data in a DacPac
body: <p>In Sql Server Data Tools for Visual Studio, you can create a Sql Server Project and import the structure of a Database.  This works very well.</p>
  
  <p>Is it also possible to import data as well?  For example, lets say I have a Type table with several types.  I would like to have this data in the Sql Server Project, so when I publish it, it publishes the data as well.</p>
  
  <p>The closest I have been able to figure out is to use Sql Server Object Explorer to create a script for the data and then manually add that script to the project.</p>
  
  <p>When I saw the demo of Sql Server Data Tools, then showed publishing a project, but then using copy and paste to get data into the database.  Surely there is a better way.</p>
  
  <p>EDIT
  Years later, I finally figure this out:  There are two types of exports: 1. DACPAK - which includes only the structure, 2. The BACBAK which includes data and structure.</p>
  
  <p>You can created either from SSMS: 1. DACPAK: Select your database, right click for Tasks-> Extract Data Tier App.  2. Select database, right click for Tasks-> Export Data Tier App.</p>