script stored procs to a file

sql dmo script.ps1

pushd;
import-module sqlps -disablenamechecking;
popd;

$s = new-object microsoft.sqlserver.management.smo.server 'localhost';
$db = $s.Databases['ps_all_the_things'];
foreach ($proc in $db.StoredProcedures | where {($_.IsSystemObject -eq $false) -and ($_.Schema -eq 'dbo')}) {
	$file = 'd:\temp\' + $proc.Name + '.sql';
	Write-Host $proc.Name;
	$proc.script() | Out-File $file;
}

$a = $s.JobServer;
foreach ($job in $a.Jobs) {
   $job.script();
}



$s = new-object microsoft.sqlserver.management.smo.server 'localhost';
$db = $s.Databases['demoDb'];
foreach ($proc in $db.StoredProcedures | 
	where {$_.Schema -eq 'dbo'}) {
	$file = 'd:\temp\' + $proc.Name + '.sql';
	Write-Host $proc.Name;
	$proc.script() | Out-File $file;
};