Microsoft SQL Server is a complex server product, with many components and tools that enable consumer success. Due to this, perfect tooling for PowerShell is not always available. On the other hand, it has one of the most active user communities, driving rapid improvement and expansion of the available tool-sets.
Currently, there are four major PowerShell modules to choose from:
|
SqlServer |
The official and supported module developed by Microsoft. It contains tools to navigate and manage SQL instances. |
|
ReportingServicesTools |
The equally official module managed by Microsoft that handles managing reporting services. Unlike the SqlServer module, it is open source and the community can contribute to it on GitHub. |
|
dbatools |
The largest community-driven PowerShell module in existence. More than 400 commands that deal with SQL Instances, covering many of the... |
