title: VS2012 Post-Deployment script referring to several other scripts
body: <p>I have created a database project in <code>VS2012</code>. I added database structure. It works fine to publish and compare database.</p>
  
  <p>Now on publish I want to automatically load several tables with default data.</p>
  
  <p>I created five script files with <code>INSERT</code> statements generated from <strong>SQL Management Studio</strong>. They were added to a Script folder in my database project. </p>
  
  <p>Then I set <code>BuildAction=PostDeploy</code>. This works fine. BUT from some reason it is only possible to have ONE script set to <code>PostDeploy</code> ....</p>
  
  <p>I realize I can move all scripts into one file. But I have a lot and would really like to group them in separate files to maintain some order.</p>
  
  <p>I then created one <code>PostDeploy.sql</code> file and tried to reference all other script files from there. The file header gives directions:</p>
  
  <pre><code>Post-Deployment Script Template                         
  ----------------------------------------------------------------------------
  This file contains SQL statements that will be appended to the build script.
  Use SQLCMD syntax to include a file in the post-deployment script.
  Example:      :r .\myfile.sql
  </code></pre>
  
  <p>So I write my file:</p>
  
  <pre><code>:r .\MyScript1.sql
  :r .\MyScript2.sql
  :r .\MyScript3.sql
  :r .\MyScript4.sql
  :r .\MyScript5.sql
  </code></pre>
  
  <p>The file complains on wrong syntax.</p>