Basic Power-Shell cmdlets to work with SQL Server (via sqlcmd.exe)

Sql-Functions.ps1

# -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
# SQL Server functions

function Execute-Sql($sql, $username, $password, $file) {
	Write-Host -ForegroundColor Cyan "Executing $file on $sql with user $username"
	& sqlcmd -S $sql -U $username -P $password -i $file
}

function Execute-SqlDir($sql, $username, $password, $dir) {
	Get-ChildItem $dir | Select-Object FullName | foreach { 
		Write-Host -ForegroundColor Cyan "Executing $_.FullName on $sql with user $username"
		Execute-Sql $sql $username $password $_.FullName 
	}
}