SQL PowerShell to the rescue

As part of on going development I was required to run all the database scripts for a new database. This was just less than 300 scripts and it was getting laborious doing it manually. So I delved into the world of SQL PowerShell and found a handy script to automate the running of these scripts.

Now the rebuild of the entire database is automated by one simple script.

Sample code: foreach ($f in Get-ChildItem -path "C:\Scripts\" -Filter *.sql | sort-object) { invoke-sqlcmd –ServerInstance "XXX" -Database "YYY" -InputFile $f.fullname -SuppressProviderContextWarning }