In this recipe, we will extract user-defined assemblies and resave these back to the filesystem as DLLs.
We can use the
SampleDB database that we used in the previous recipe, or you can substitute this with any database that is accessible to you that has some user-defined assemblies.
These are the steps required to extract user-defined assemblies:
SQLPSmodule as follows:
#import SQL Server module Import-Module SQLPS -DisableNameChecking
$VerbosePreference = "Continue" $instanceName = "localhost" $timestamp = Get-Date -format "yyyy-MMM-dd-hhmmtt" $emptyBLOB = "SampleDB.dbo.EmptyBLOB" ...