blocks|key|239247|text|[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|239248|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
</code></pre>

blocks|key|456461|text|LoadWithPartialName已被弃用。对于PowerShell+V3，推荐的解决方案是使用Add-Type+cmdlet，例如：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|456462|Add-Type+-Path+'C:\Program+Files\Microsoft+SQL+Server\110\SDK\Assemblies\Microsoft.SqlServer.Smo.dll'|code-block|syntax|javascript|456463|有多个不同的版本，您可能希望选择一个特定的版本。:-)|456464|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/add-type^0|0|J|1E|8|1E|8|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|13|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

<code>LoadWithPartialName</code> has been deprecated. The recommended solution for PowerShell V3 is to use the <a href="https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/add-type" rel="nofollow noreferrer"><code>Add-Type</code></a> cmdlet e.g.:
<pre><code>Add-Type -Path 'C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Smo.dll'
</code></pre>
There are multiple different versions and you may want to pick a particular version. :-)

blocks|key|239287|text|可以使用以下命令加载整个*.dll程序集|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239288|$Assembly+=+[System.Reflection.Assembly]::LoadFrom("C:\folder\file.dll");|code-block|syntax|javascript|239289|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can load the whole *.dll assembly with 

<pre><code>$Assembly = [System.Reflection.Assembly]::LoadFrom("C:\folder\file.dll");
</code></pre>

blocks|key|239296|text|[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")为我工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|239297|entityMap^0|0|24|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

<code>[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")</code> worked for me.

blocks|key|239506|text|您可以使用LoadWithPartialName。然而，正如他们所说的那样，这是不受欢迎的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|239507|您确实可以使用Add-Type，除了其他答案之外，如果您不想指定.dll文件的完整路径，您可以简单地这样做：|239508|Add-Type+-AssemblyName+"Microsoft.SqlServer.Management.SMO"|code-block|syntax|javascript|239509|对我来说，这返回了一个错误，因为我没有安装SQL+Server+(我猜)，但是，基于同样的想法，我能够加载Windows窗体程序集：|239510|Add-Type+-AssemblyName+"System.Windows.Forms"|239511|您可以在MSDN站点上找到属于特定类的确切程序集名称：|239512|​|239513|📷|atomic|239514|239515|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d6d01e09bdd0ab39ec8cd20ac0e6d64d.png|imageAlt^0|5|J|0|7|8|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1D|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1E|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1F|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1G|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|1H|8|@]|D|@]|E|$]]|$1|U|3|V|5|W|7|1I|8|@]|D|@$9|1J|A|1K|1|1L]]|E|$]]|$1|X|3|T|5|6|7|1M|8|@]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]]|Z|$10|$5|11|12|13|E|$14|15|16|-4]]]]

You could use <code>LoadWithPartialName</code>. However, that is deprecated as they said.

You can indeed go along with <code>Add-Type</code>, and in addition to the other answers, if you don't want to specify the full path of the .dll file, you could just simply do:

<pre><code>Add-Type -AssemblyName "Microsoft.SqlServer.Management.SMO"
</code></pre>

To me this returned an error, because I do not have SQL Server installed (I guess), however, with this same idea I was able to load the Windows Forms assembly:

<pre><code>Add-Type -AssemblyName "System.Windows.Forms"
</code></pre>

You can find out the precise assembly name belonging to the particular class on the MSDN site:

<a href="https://i.stack.imgur.com/6PuKE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6PuKE.png" alt="Example of finding out assembly name belonging to a particular class"></a>

blocks|key|456605|text|没有一个答案对我有帮助，所以我发布了对我有效的解决方案，我所要做的就是导入SQLPS模块，当我偶然运行Restore-SqlDatabase命令并开始工作时，我意识到这一点，这意味着该程序集以某种方式在该模块中被引用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|456606|只需运行：|456607|Import-module+SQLPS|code-block|syntax|javascript|456608|注意:感谢Jason指出SQLPS已被弃用|456609|而是运行：|456610|Import-Module+SqlServer|456611|或|456612|Install-Module+SqlServer|456613|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|Z|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

None of the answers helped me, so I'm posting the solution that worked for me, all I had to do is to import the SQLPS module, I realized this when by accident I ran the Restore-SqlDatabase command and started working, meaning that the assembly was referenced in that module somehow.

Just run:

<pre><code>Import-module SQLPS
</code></pre>

Note: Thanks Jason for noting that SQLPS is deprecated

instead run:

<pre><code>Import-Module SqlServer
</code></pre>

or

<pre><code>Install-Module SqlServer
</code></pre>

The following PowerShell code

<pre><code>#Get a server object which corresponds to the default instance
$srv = New-Object -TypeName Microsoft.SqlServer.Management.SMO.Server
... rest of the script ...
</code></pre>

Gives the following error message: 

<pre><code>New-Object : Cannot find type [Microsoft.SqlServer.Management.SMO.Server]: make sure 
the assembly containing this type is loaded.
At C:\Users\sortelyn\ ... \tools\sql_express_backup\backup.ps1:6 char:8
+ $srv = New-Object -TypeName Microsoft.SqlServer.Management.SMO.Server
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidType: (:) [New-Object], PSArgumentException
+ FullyQualifiedErrorId : TypeNotFound,Microsoft.PowerShell.Commands.NewObjectCommand
</code></pre>

Every answer on the Internet writes that I have to load the assembly - well sure I can read that from the error message :-) - the question is: 

How do you load the assembly and make the script work?

How to load assemblies in PowerShell?

SQL Server

Windows

下面的PowerShell代码#Get a server object which corresponds to the default instance$srv = New-Object -TypeName Microsoft.SqlServer.Management.SMO.Server... rest of th...

问如何在PowerShell中加载程序集？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PowerShell中加载程序集？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PowerShell中加载程序集？
EN