Export MSSQL Stored Procedures with Powershell

Export-Procedures.ps1

# Start Script
Set-ExecutionPolicy RemoteSigned

$servername = 'SQL01';
$dbname = 'DATABASE';
$scriptpath = 'C:\Users\johndoe\Desktop\Procedures';

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("System.Data") | Out-Null
$srv = new-object "Microsoft.SqlServer.Management.SMO.Server" $serverName

$srv.SetDefaultInitFields([Microsoft.SqlServer.Management.SMO.View], "IsSystemObject")

$db = New-Object "Microsoft.SqlServer.Management.SMO.Database"

$db = $srv.Databases[$dbname]

$scr = New-Object "Microsoft.SqlServer.Management.Smo.Scripter"

$deptype = New-Object "Microsoft.SqlServer.Management.Smo.DependencyType"

$scr.Server = $srv

$options = New-Object "Microsoft.SqlServer.Management.SMO.ScriptingOptions"

$options.AllowSystemObjects = $false
$options.IncludeDatabaseContext = $true
$options.IncludeIfNotExists = $false
$options.ClusteredIndexes = $true
$options.Default = $true
$options.DriAll = $true
$options.Indexes = $true
$options.NonClusteredIndexes = $true
$options.IncludeHeaders = $false
$options.ToFileOnly = $true
$options.AppendToFile = $false
$options.ScriptDrops = $false 

# Set options for SMO.Scripter
$scr.Options = $options

$StoredProcedures = $db.StoredProcedures | where {$_.IsSystemObject -eq $false}

Foreach ($StoredProcedure in $StoredProcedures) {
    $options.FileName = $scriptpath + "\$($StoredProcedure).sql"

    New-Item $options.FileName -type file -force | Out-Null

    if ($StoredProcedures -ne $null) {   
        $scr.Script($StoredProcedure)
    }
}