Help on Powershell SMO running on Ubuntu Container

[aldwinting]

I'm getting this error on SMO Script from this Repo and also I'm running this powershell script on a Ubuntu Docker Container.

Docker File:

FROM MyImagePWS

RUN  apt-get update \
  && apt-get install -y wget \
  && rm -rf /var/lib/apt/lists/*

RUN wget https://github.com/Microsoft/sqltoolsservice/releases/download/v1.0.0-alpha.34/microsoft.sqltools.credentials-ubuntu16-x64-netcoreapp2.0.tar.gz
RUN tar -xzvf microsoft.sqltools.credentials-ubuntu16-x64-netcoreapp2.0.tar.gz 

COPY Test5.ps1 .

CMD [ "pwsh", "Test5.ps1"]

Test5.ps1

$Assem = (
    "System.Data.Common",
    "System.Data.SqlClient",
    “Microsoft.SqlServer.Management.Sdk.Sfc”,
    “Microsoft.SqlServer.Smo”,
    “Microsoft.SqlServer.ConnectionInfo”,
    "Microsoft.SqlServer.SmoExtended"

)

Add-Type -AssemblyName $Assem;

  $sourceConn = New-Object System.Data.SqlClient.SqlConnection("Data Source=$sourceSVR",
        (new-object System.Data.SqlClient.SqlCredential($usernameENV.value, $securepassword)))

 $s = new-object ('Microsoft.SqlServer.Management.Smo.Server') $sourceConn  
 $dbs=$s.Databases 
 $dbs[$dbase].Script()  | Out-File "$($dbase)_build.sql"

The Error
Exception calling "Script" with "0" argument(s): "Script failed for Database 'TestDatabase' ."

More Details Error:

Exception             : System.Management.Automation.MethodInvocationException:
                          Exception calling "Script" with "0" argument(s): 
                         "Script failed for Database 'TestDatabase'. " ---> Microsoft.
                         SqlServer.Management.Smo.FailedOperationException: 
                         Script failed for Database 'TestDatabase'.  ---> 
                         System.TypeInitializationException: The type 
                         initializer for 
                         'Microsoft.SqlServer.Management.Smo.TypeConverters' 
                         threw an exception. ---> 
                         System.Reflection.TargetInvocationException: Exception 
                         has been thrown by the target of an invocation. ---> 
                         System.Resources.MissingManifestResourceException: 
                         Could not find any resources appropriate for the 
                         specified culture or the neutral culture.  Make sure "M
                         icrosoft.SqlServer.Management.Smo.LocalizableResources.
                         resources" was correctly embedded or linked into 
                         assembly "Microsoft.SqlServer.Smo" at compile time, or 
                         that all the satellite assemblies required are 
                         loadable and fully signed.
                            at System.Resources.ManifestBasedResourceGroveler.Ha
                         ndleResourceStreamMissing(String fileName)
                            at System.Resources.ManifestBasedResourceGroveler.Gr
                         ovelForResourceSet(CultureInfo culture, Dictionary`2 
                         localResourceSets, Boolean tryParents, Boolean 
                         createIfNotExists, StackCrawlMark& stackMark)
                            at System.Resources.ResourceManager.InternalGetResou
                         rceSet(CultureInfo requestedCulture, Boolean 
                         createIfNotExists, Boolean tryParents, StackCrawlMark& 
                         stackMark)
                            at System.Resources.ResourceManager.InternalGetResou
                         rceSet(CultureInfo culture, Boolean createIfNotExists, 
                         Boolean tryParents)
                            at 
                         System.Resources.ResourceManager.GetString(String 
                         name, CultureInfo culture)
                            at Microsoft.SqlServer.Management.Sdk.Sfc.Localizabl
                         eEnumConverter.LoadLocalizedFieldNames(Type type, 
                         ResourceManager manager)
                            at Microsoft.SqlServer.Management.Sdk.Sfc.Localizabl
                         eEnumConverter.LoadLocalizedNames(Type type, 
                         ResourceManager manager)
                            at Microsoft.SqlServer.Management.Sdk.Sfc.Localizabl
                         eEnumConverter..ctor(Type type)
                            --- End of inner exception stack trace ---
                            at System.RuntimeMethodHandle.InvokeMethod(Object 
                         target, Object[] arguments, Signature sig, Boolean 
                         constructor, Boolean wrapExceptions)
                            at System.Reflection.RuntimeConstructorInfo.Invoke(B
                         indingFlags invokeAttr, Binder binder, Object[] 
                         parameters, CultureInfo culture)
                            at System.ComponentModel.ReflectTypeDescriptionProvi
                         der.CreateInstance(Type objectType, Type callingType)
                            at System.ComponentModel.ReflectTypeDescriptionProvi
                         der.ReflectedTypeData.GetConverter(Object instance)
                            at System.ComponentModel.TypeDescriptor.TypeDescript
                         ionNode.DefaultTypeDescriptor.System.ComponentModel.ICu
                         stomTypeDescriptor.GetConverter()
                            at 
                         System.ComponentModel.TypeDescriptor.GetConverter(Type 
                         type)
                            at Microsoft.SqlServer.Management.Smo.TypeConverters
                         ..cctor()
                            --- End of inner exception stack trace ---
                            at Microsoft.SqlServer.Management.Smo.ScriptMaker.Sc
                         riptWorker(List`1 urns, ISmoScriptWriter writer)
                            at Microsoft.SqlServer.Management.Smo.ScriptMaker.Sc
                         ript(SqlSmoObject[] objects, ISmoScriptWriter writer)
                            at Microsoft.SqlServer.Management.Smo.ScriptMaker.Sc
                         ript(SqlSmoObject[] objects)
                            at Microsoft.SqlServer.Management.Smo.SqlSmoObject.E
                         numScriptImplWorker(ScriptingPreferences sp)
                            at Microsoft.SqlServer.Management.Smo.SqlSmoObject.E
                         numScriptImpl(ScriptingPreferences sp)
                            --- End of inner exception stack trace ---
                            at Microsoft.SqlServer.Management.Smo.SqlSmoObject.E
                         numScriptImpl(ScriptingPreferences sp)
                            at Microsoft.SqlServer.Management.Smo.SqlSmoObject.S
                         criptImpl(ScriptingPreferences sp)
                            at Microsoft.SqlServer.Management.Smo.SqlSmoObject.S
                         criptImpl()
                            at CallSite.Target(Closure , CallSite , Object )
                            --- End of inner exception stack trace ---
                            at System.Management.Automation.ExceptionHandlingOps
                         .CheckActionPreference(FunctionContext funcContext, 
                         Exception exception)
                            at System.Management.Automation.Interpreter.ActionCa
                         llInstruction`2.Run(InterpretedFrame frame)
                            at System.Management.Automation.Interpreter.EnterTry
                         CatchFinallyInstruction.Run(InterpretedFrame frame)
                            at System.Management.Automation.Interpreter.EnterTry
                         CatchFinallyInstruction.Run(InterpretedFrame frame)
 TargetObject          : 
 CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
 FullyQualifiedErrorId : FailedOperationException
 ErrorDetails          : 
 InvocationInfo        : System.Management.Automation.InvocationInfo
 ScriptStackTrace      : at <ScriptBlock>, /Test6.ps1: line 85
 PipelineIterationInfo : {}
 PSMessageDetails 

Looks like I'm getting error on the .Script() part.

Is there a latest version for Ubuntu 20.04.5 LTS.

What do I need to do to make my SMO POwershell work on a Ubuntu Container? Thanks!

[cheenamalhotra]

@aldwinting

You seem to be using a very old version of STS release - any special reason you're using v1.0.0-alpha.34?

If you simply want to use SMO, you should use this NuGet and its dependencies instead: https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects