Skip to content

install-sql-server-powershell.md

Latest commit

 

History

History
38 lines (27 loc) · 3.17 KB

install-sql-server-powershell.md

File metadata and controls

38 lines (27 loc) · 3.17 KB
title Install SQL Server PowerShell | Microsoft Docs
description This article describes the SQL Server PowerShell components that Setup installs when you select SQL Server features that require PowerShell support.
ms.custom
intro-installation
ms.date 09/05/2017
ms.prod sql
ms.reviewer
ms.technology install
ms.topic conceptual
ms.assetid 854c0b2f-02d2-46a4-a8cc-6b7a5d191cf8
author MikeRayMSFT
ms.author mikeray
monikerRange >=sql-server-2016

Install SQL Server PowerShell

[!INCLUDE SQL Server -Windows Only]

[!INCLUDEssNoVersion] Setup automatically configures PowerShell components.

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.

For more information, see: