dbatools -the tiny universal database management solution - PowerShell
Definition
dbatools is a free PowerShell module with over 500 SQL Server administration, best practice and migration commands included. You can think of dbatools as a command-line SQL Server Management Studio
Minimum Requirements
Server
- SQL Server 2000
- No PowerShell needed on the host for SQL Server-only commands
- PowerShell remoting enabled on the host for remote Windows commands
Workstation
- Windows 7 with PowerShell 3
- Linux or macOS with PowerShell 6.1
Support
dbatools aims to support as many configurations as possible, including
- SQL Server 2000 – 2017
- Express – Datacenter Edition
- Clustered and stand-alone instances
- Windows and SQL authentication
- Default and named instances
- Multiple instances on one server
- Auto-populated parameters for command-line completion (think -Database and -Login)
More information
Want to know more? The dbatools blog has a lot of great articles and all my database managment scripts presented here are based on it.
Reference: