Script-DBObjectsForSSC.ps1

# base function
function global:Script-DBObjectsIntoFolders([string]$server, [string]$dbname){
	[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null
	
	$SMOserver = New-Object (’Microsoft.SqlServer.Management.Smo.Server’) -argumentlist $server
	$db = $SMOserver.databases[$dbname]

	$Objects = $db.Tables
	$Objects += $db.Views
	$Objects += $db.StoredProcedures
	$Objects += $db.UserDefinedFunctions
	$Objects += $db.Schemas
	$Objects += $db.Triggers

# Build this portion of the directory structure out here in case scripting takes more than one minute.
	$SavePath = "E:\Dexma\Temp\Databases\" + $($dbname)
	$DateFolder = get-date -format yyyyMMddHHmm
	new-item -type directory -name "$DateFolder"-path "$SavePath"

	foreach ($ScriptThis in $Objects | where {!($_.IsSystemObject)}) {
		# Need to Add Some mkDirs for the different $Fldr=$ScriptThis.GetType().Name 
		$scriptr = new-object ('Microsoft.SqlServer.Management.Smo.Scripter') ($SMOserver)
		$scriptr.Options.AppendToFile = $True
		$scriptr.Options.AllowSystemObjects = $False
		$scriptr.Options.ClusteredIndexes = $True
		$scriptr.Options.DriAll = $True
		$scriptr.Options.ScriptDrops = $False
		$scriptr.Options.IncludeHeaders = $True
		$scriptr.Options.ToFileOnly = $True
		$scriptr.Options.Indexes = $True
		$scriptr.Options.Permissions = $True
		$scriptr.Options.WithDependencies = $False
		<#Script the Drop too#>
		$ScriptDrop = new-object ('Microsoft.SqlServer.Management.Smo.Scripter') ($SMOserver)
		$ScriptDrop.Options.AppendToFile = $True
		$ScriptDrop.Options.AllowSystemObjects = $False
		$ScriptDrop.Options.ClusteredIndexes = $True
		$ScriptDrop.Options.DriAll = $True
		$ScriptDrop.Options.ScriptDrops = $True
		$ScriptDrop.Options.IncludeHeaders = $True
		$ScriptDrop.Options.ToFileOnly = $True
		$ScriptDrop.Options.Indexes = $True
		$ScriptDrop.Options.WithDependencies = $False

		<#This section builds folder structures.  Remove the date folder if you want to overwrite#>
		$TypeFolder=$ScriptThis.GetType().Name 
		if ((Test-Path -Path "$SavePath\$DateFolder\$TypeFolder") -eq "true") `
        	{"Scripting Out $TypeFolder $ScriptThis"} `
    	else {new-item -type directory -name "$TypeFolder"-path "$SavePath\$DateFolder"}
		$ScriptFile = $ScriptThis -replace "\[|\]"
		$ScriptDrop.Options.FileName = "" + $($SavePath) + "\" + $($DateFolder) + "\" + $($TypeFolder) + "\" + $($ScriptFile) + ".SQL"
		$scriptr.Options.FileName = "$SavePath\$DateFolder\$TypeFolder\$ScriptFile.SQL"

		# This is where each object actually gets scripted one at a time.
		IF ($ScriptThis.GetType().Name -NE "Table") { $ScriptDrop.Script($ScriptThis) }
		$scriptr.Script($ScriptThis)
	} # This ends the loop
} # This completes the function

#Script-DBObjectsIntoFolders "XSQLUTIL19" "AScriptingTestDB"
Script-DBObjectsIntoFolders "XSQLUTIL19" "CitizensFirst_NdxTest"