title: Restore SQL Server database from .sql files
body: <p>So we had an encrypted database that puked and killed our whole SQL Server setup. Sucks about our data, but we were smart enough to have our Data structure/Stored Procs/Functions in Git</p>
  
  <p>The problem is they're saved as <code>.sql</code> files.</p>
  
  <p>Is there any way we can batch restore our schema from directories full of these files?</p>
  
  <p>I've looked around and I can only find tutorials for restoring from <code>.bak</code> files or <code>.mdf</code>'s. This isn't the lazy man's way out- I just need to find a solution ASAP. Any advice or resources/ anything at all would be greatly appreciated.</p>
  
  <p>Thanks Interwebs,</p>
  
  <p>Dylan</p>