Powershell - Use SQLCMD to run all scripts in a folder on one target database

Post date: Dec 20, 2011 1:24:15 PM

Homework: make it run on every database on the server

cls [System.IO.DirectoryInfo]$workdir = New-Object System.IO.DirectoryInfo("C:\src\database")$files = $workdir.GetFiles() | where {$_.Extension -eq ".sql"} Set-Location SQLSERVER:\SQL\Localhost\DEFAULT\Databases\CustomerDB foreach( $file in $files){ Invoke-Sqlcmd -InputFile $file.FullName #Write-Host $file.Name}