title: Deploy different seed data for different publish profiles using visual studio ssdt?
body: <p>Is it possible to deploy different sets of seed data for different publish profiles using visual studio Sql Server Data tools database project?</p>
  
  <p>We know you can deploy seed data using a post deployment script.
  We know you can deploy to different environments using the publish profiles facility.
  What we don't know is how you can deploy different seed data to the different environments.</p>
  
  <p>Why would we want to do this?</p>
  
  <ul>
  <li>We want to be able to do this so we can have a small explicit set of seed data for unit testing against.</li>
  <li>We need a wider set of data to deploy to the test team's environment for the test team to test the whole application against</li>
  <li>We need a specific set of seed data for the pre-prod environment.</li>
  </ul>