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}