internal/scripts/smoLibraryImport.ps1
$scriptBlock = { Param ( $ModuleRoot, $DllRoot, $DoCopy ) function Copy-Assembly { [CmdletBinding()] Param ( [string]$ModuleRoot, [string]$DllRoot, [bool]$DoCopy, [string]$Name ) if (-not $DoCopy) { return } if ("$ModuleRoot\bin\smo" -eq $DllRoot) { return } if (-not (Test-Path $DllRoot)) { $null = New-Item -Path $DllRoot -ItemType Directory -ErrorAction Ignore } Copy-Item -Path "$ModuleRoot\bin\smo\$Name.dll" -Destination $DllRoot } #region Names $names = @( 'Microsoft.SqlServer.BatchParser', 'Microsoft.SqlServer.BatchParserClient', 'Microsoft.SqlServer.BulkInsertTaskConnections', 'Microsoft.SqlServer.DTSRuntimeWrap', 'Microsoft.SqlServer.DtsServer.Interop', 'Microsoft.SqlServer.DTSUtilities', 'Microsoft.SqlServer.ForEachFileEnumeratorWrap', 'Microsoft.SqlServer.ManagedDTS', 'Microsoft.SqlServer.IntegrationServices.ODataConnectionManager', 'Microsoft.SqlServer.IntegrationServices.ODataSrc', 'Microsoft.SqlServer.PipelineHost', 'Microsoft.SqlServer.PackageFormatUpdate', 'Microsoft.SqlServer.Replication', 'Microsoft.SqlServer.SqlCEDest', 'Microsoft.SqlServer.SQLTask', 'Microsoft.SqlServer.TxScript', 'Microsoft.SqlServer.XE.Core', 'Microsoft.SqlServer.XEvent.Configuration', 'Microsoft.SqlServer.XEvent', 'Microsoft.SqlServer.XEvent.Linq', 'Microsoft.SqlServer.XmlSrc', 'Microsoft.SqlServer.Rmo', 'Microsoft.SqlServer.DTSPipelineWrap', 'Microsoft.SqlServer.ScriptTask', 'Accessibility', 'EnvDTE', 'Microsoft.AnalysisServices.AppLocal.Core', 'Microsoft.AnalysisServices.AppLocal', 'Microsoft.Azure.KeyVault.Core', 'Microsoft.Data.Edm', 'Microsoft.Data.OData', 'Microsoft.Practices.TransientFaultHandling.Core', 'Microsoft.DataTransfer.Common.Utils', 'Microsoft.SqlServer.ASTasks', 'Microsoft.SqlServer.ConnectionInfo', 'Microsoft.SqlServer.ConnectionInfoExtended', 'Microsoft.SqlServer.DataProfiler', 'Microsoft.SqlServer.DataProfilingTask', 'Microsoft.SqlServer.Diagnostics.STrace', 'Microsoft.SqlServer.Dmf.Common', 'Microsoft.SqlServer.Dmf', 'Microsoft.SqlServer.DMQueryTask', 'Microsoft.SqlServer.DTEnum', 'Microsoft.SqlServer.Dts.Design', 'Microsoft.SqlServer.Dts.DtsClient', 'Microsoft.SqlServer.DtsMsg', 'Microsoft.SqlServer.Edition', 'Microsoft.SqlServer.ExecProcTask', 'Microsoft.SqlServer.ExpressionTask', 'Microsoft.SqlServer.FileSystemTask', 'Microsoft.SqlServer.ForEachADOEnumerator', 'Microsoft.SqlServer.ForEachFromVarEnumerator', 'Microsoft.SqlServer.ForEachNodeListEnumerator', 'Microsoft.SqlServer.ForEachSMOEnumerator', 'Microsoft.SqlServer.FtpTask', 'Microsoft.SqlServer.GridControl', 'Microsoft.SqlServer.Instapi', 'Microsoft.SqlServer.IntegrationServices.ClusterManagement', 'Microsoft.SqlServer.IntegrationServices.Common.ObjectModel', 'Microsoft.SqlServer.IntegrationServices.ISServerDBUpgrade', 'Microsoft.SqlServer.IntegrationServices.Server.Common', 'Microsoft.SqlServer.IntegrationServices.Server', 'Microsoft.SqlServer.IntegrationServices.Server.IPC', 'Microsoft.SqlServer.IntegrationServices.server.shared', 'Microsoft.SqlServer.IntegrationServices.TaskScheduler', 'Microsoft.SqlServer.ManagedConnections', 'Microsoft.SqlServer.Management.Collector', 'Microsoft.SqlServer.Management.CollectorEnum', 'Microsoft.SqlServer.Management.CollectorTasks', 'Microsoft.SqlServer.Management.HadrDMF', 'Microsoft.SqlServer.Management.HelpViewer', 'Microsoft.SqlServer.Management.IntegrationServices', 'Microsoft.SqlServer.Management.IntegrationServicesEnum', 'Microsoft.SqlServer.Management.RegisteredServers', 'Microsoft.SqlServer.Management.Sdk.Sfc', 'Microsoft.SqlServer.Management.SmartAdminPolicies', 'Microsoft.SqlServer.Management.SqlParser', 'Microsoft.SqlServer.Management.SystemMetadataProvider', 'Microsoft.SqlServer.Management.Utility', 'Microsoft.SqlServer.Management.UtilityEnum', 'Microsoft.SqlServer.Management.XEvent', 'Microsoft.SqlServer.Management.XEventDbScoped', 'Microsoft.SqlServer.Management.XEventDbScopedEnum', 'Microsoft.SqlServer.Management.XEventEnum', 'Microsoft.SqlServer.MSMQTask', 'Microsoft.SqlServer.PipelineXML', 'Microsoft.SqlServer.PolicyEnum', 'Microsoft.SqlServer.RegSvrEnum', 'Microsoft.SqlServer.Replication.BusinessLogicSupport', 'Microsoft.SqlServer.SendMailTask', 'Microsoft.SqlServer.ServiceBrokerEnum', 'Microsoft.SqlServer.Smo', 'Microsoft.SqlServer.SmoExtended', 'Microsoft.SqlServer.SqlClrProvider', 'Microsoft.SqlServer.SqlEnum', 'Microsoft.SqlServer.SQLTaskConnectionsWrap', 'Microsoft.SqlServer.SqlTDiagm', 'Microsoft.SqlServer.SqlWmiManagement', 'Microsoft.SqlServer.SString', 'Microsoft.SqlServer.TransferDatabasesTask', 'Microsoft.SqlServer.TransferErrorMessagesTask', 'Microsoft.SqlServer.TransferJobsTask', 'Microsoft.SqlServer.TransferLoginsTask', 'Microsoft.SqlServer.TransferObjectsTask', 'Microsoft.SqlServer.TransferSqlServerObjectsTask', 'Microsoft.SqlServer.TransferStoredProceduresTask', 'Microsoft.SqlServer.Types', 'Microsoft.SqlServer.Types.resources', 'Microsoft.SqlServer.VSTAScriptingLib', 'Microsoft.SqlServer.WebServiceTask', 'Microsoft.SqlServer.WMIDRTask', 'Microsoft.SqlServer.WmiEnum', 'Microsoft.SqlServer.WMIEWTask', 'Microsoft.SqlServer.XMLTask', 'Microsoft.SqlServer.Dmf.Adapters', 'Microsoft.SqlServer.DmfSqlClrWrapper', 'Microsoft.Data.Tools.Utilities', 'Microsoft.SqlServer.TransactSql.ScriptDom', 'Microsoft.Data.Tools.Components', 'Microsoft.Data.Tools.Contracts', 'Microsoft.SqlServer.Dac.Extensions', 'Microsoft.SqlServer.Dac' 'Microsoft.Data.Tools.Schema.Sql', 'Microsoft.Data.Tools.Schema.Utilities.Sql' ) #endregion Names foreach ($name in $names) { Copy-Assembly -ModuleRoot $ModuleRoot -DllRoot $DllRoot -DoCopy $DoCopy -Name $name } foreach ($name in $names) { Add-Type -Path "$DllRoot\$name.dll" } <# Likely don't need yet Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.WizardFramework.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.WizardFrameworkLite.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.WorkerAgent.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.SqlTaskScheduler.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.CustomControls.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.MasterService.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.MasterServiceClient.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.Practices.TransientFaultHandling.Core.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.Scale.ResourceProvider.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.Scale.ScaleoutContract.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.ScaleOut.Telemetry.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.ScaleOut.Utilities.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationService.Hadoop.Common.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationService.HadoopComponents.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationService.HadoopConnections.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationService.HadoopEnumerators.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationService.HadoopTasks.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.ExceptionMessageBox.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlTools.Telemetry.Interop.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.Ssdqs.Component.DataCorrection.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.Ssdqs.Component.DataQualityConnectionManager.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.WindowsAzure.Configuration.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.WindowsAzure.Storage.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.WindowsAzure.StorageClient.dll" # Throws exceptions but likes to be added Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.Data.Services.Client.dll" -ErrorAction Stop Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.DataTransfer.Common.dll" -ErrorAction Stop Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.DataTransfer.DataContracts.dll" -ErrorAction Stop Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.AnalysisServices.AppLocal.Tabular.dll" -ErrorAction Stop Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.Management.SmoMetadataProvider.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.Hadoop.Avro.dll" # Can't load, won't load Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.Data.DataFeedClient.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.DataTransfer.ClientLibrary.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.ADONETDest.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.ADONETSrc.dllv" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.BulkInsertTask.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.DataReaderDest.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.DataStreaming.Dest.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.DTSPipelineWrap.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.IntegrationServices.RuntimeTelemetry.dll" Add-Type -Path "$script:PSModuleRoot\bin\smo\Microsoft.SqlServer.MaintenancePlanTasks.dll" #> } if ($script:serialImport) { $scriptBlock.Invoke($script:PSModuleRoot, "$script:DllRoot\smo", (-not $script:strictSecurityMode)) } else { $script:smoRunspace = [System.Management.Automation.PowerShell]::Create() try { $script:smoRunspace.Runspace.Name = "dbatools-import-smo" } catch { } $script:smoRunspace.AddScript($scriptBlock).AddArgument($script:PSModuleRoot).AddArgument("$script:DllRoot\smo").AddArgument((-not $script:strictSecurityMode)) $script:smoRunspace.BeginInvoke() } |