title: Export Data-Tier Application with Data (bacpac) from a database that contains encrypted objects
body: <p>I have a SQL Server 2012 Database project that I have been working on for deployment of our database.  The dacpac deployments are working great but I have run into a roadblock when it comes to deploying data along with the schema.</p>
  
  <p>My plan was to have a local copy of the database that contains all of the default data so that I could deploy the dacpac to that database then export a bacpac that contains the latest schema as well as the default data set for deployment to remote sites.</p>
  
  <p>However, we have a handful of objects in the database that are encrypted and the bacpac export fails on those objects.  Is there a way to export a bacpac from a database that contains encrypted objects or how might you recommend addressing this issue?</p>
  
  <p>Edit: I am also running into issues with objects that reference system databases such as Master and MSDB if you have any suggestions for that.</p>