Categories
PowerShell Scripting

PowerShell Add SQL Modules

Modules can now be added by using Import-Module. The following example list all the available.

Get-Module -ListAvailable

Load the SQLPS module (if available)….

Import-Module -Name "SQLPS"

Before you can import the SQLPS powershell module you need to install SQL Management Studio or install theĀ SQLSysCLRTypes, SharedManagementObjects and PowerShellTools packagesĀ from the SQL Server Feature Pack.