| title | Install SQL Server PowerShell | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 09/05/2017 | ||
| ms.prod |
|
||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| ms.assetid | 854c0b2f-02d2-46a4-a8cc-6b7a5d191cf8 | ||
| caps.latest.revision | 9 | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| manager | jhubbard |
[!INCLUDEssNoVersion] Setup automatically configures PowerShell components.
Installing [!INCLUDEssNoVersion] PowerShell Support
You install the software that provides [!INCLUDEssNoVersion] support for Windows PowerShell by using [!INCLUDEssNoVersion] Setup. When you select any [!INCLUDEssNoVersion] features that require PowerShell support Setup installs the following [!INCLUDEssNoVersion] PowerShell components:
-
The [!INCLUDEssNoVersion] PowerShell snap-ins. The snap-ins are dll files that implement two types of Windows PowerShell support for [!INCLUDEssNoVersion]:
-
A set of [!INCLUDEssNoVersion] cmdlets. Cmdlets are commands that implement a specific action. For example, Invoke-Sqlcmd runs a [!INCLUDEtsql] or XQuery script that can also be run by using the sqlcmd utility, and Invoke-PolicyEvaluation reports whether [!INCLUDEssNoVersion] objects comply with policy-based management policies.
-
A [!INCLUDEssNoVersion] provider. The provider lets you navigate the hierarchy of [!INCLUDEssNoVersion] objects using a path similar to a file system path. Each object is associated with a class from the [!INCLUDEssNoVersion] Management object models. You can use the methods and properties of the class to perform work on the objects. For example, if you cd to a databases object in a path, you can use the methods and properties of the Microsoft.SqlServer.Managment.SMO.Database class to manage the database.
-
-
The sqlps module that is imported into Windows PowerShell sessions to load the [!INCLUDEssNoVersion] snap-ins.
-
[!INCLUDEssManStudioFull] supports starting Windows PowerShell sessions from the Object Explorer tree. [!INCLUDEssNoVersion] Agent supports Windows PowerShell job steps.
Windows Server 2012 and later and Windows 8 and later come with PowerShell installed and configured. For information about installing Windows PowerShell see Installing Windows PowerShell.