title: SSDT Post Deployment Script - Run All Scripts In Folder
body: <p>I have a PostDeployment script in a SQL project which runs a number of other scripts in the project when published:</p>
  
  <pre><code>:r .\Scripts\Script1.sql 
  :r .\Scripts\Script2.sql 
  :r .\Scripts\Script3.sql 
  :r .\Scripts\Script4.sql
  </code></pre>
  
  <p>Rather than having to manually update this each time a new script is added to the Scripts folder in source control (TFS) is it possible to just iterate and execute all the SQL scripts within the Scripts folder?</p>