A set of tools that cover the SQL Server lifecycle end to end: install to a standard, run it day to day, make it highly available, migrate it, and document all of it. Every tool stands on its own, and they interlock where that actually helps.
The common ground is dbatools. Where dbatools gives you the individual commands, these tools add the operational process around them — the GUI, the runbook, and the HTML report that proves what happened.
How the tools follow one another in practice:
SQLSetupTool Standardized installation
|
v
sqmSQLTool Day-to-day administration
|
+---------+---------+
| | |
v v v
AlwaysOn Migration Partition Specialized tasks
| | |
+---------+---------+
|
v
HTML reports / GUI Evidence and documentation
How the tools actually depend on each other — deliberately kept separate from the lifecycle, because the two are not the same graph:
dbatools
|
+-- sqmSQLTool RequiredModules: dbatools
| |
| +-- sqmPartitionTool RequiredModules: dbatools + sqmSQLTool >= 1.9.2.0
| +-- SQLSetupTool Imports sqmSQLTool at runtime
|
+-- AlwaysOnSetup uses dbatools directly
SQLMigration standalone
Every other tool runs independently and requires neither sqmSQLTool nor any of the others.
| Project | Purpose |
|---|---|
| SQLSetupTool · site | Fully automated, standardized SQL Server installation and configuration (WinForms) |
| sqmSQLTool · site | Administration framework: 155 functions for reporting, health checks, maintenance and security auditing (PowerShell Gallery) |
| AlwaysOnSetup · site | Fully automated setup of AlwaysOn availability groups |
| SQLMigration · site | Two-phase SQL Server migration across separated networks |
| sqmPartitionTool · site | Table partitioning with an automatic sliding window (GUI and CLI) |
| sqmDataTransfer · site | Table-data transfer between SQL Server instances (dbatools-based), with metadata scripting and row-count reconciliation |
| InplaceUpDate · site | In-place upgrades that back up every dependency, with a runbook |
| SSRSDeploymentTool · site | SSRS report deployment through the REST API v2.0 |
| ReportServerCheck · site | 20 RDL diagnostic reports for SSRS and Power BI Report Server |
| DeadlockCollector · site | Automatic deadlock capture from the system_health XEvent session |
| OperationsManager · site | Reporting layer over the SCOM OperationsManagerDW with SQL Server inventory |
| SsisAnalyzer · site | SSIS analysis and documentation: control flow, version comparison, data lineage (.NET 9) |
| SqlRefactorAnalyzer · site | T-SQL refactoring and execution plan analysis, strictly read-only (C#/WinForms) — binaries |
| DbSchemaCompare · site | Full schema comparison between two live SQL Server databases in a single HTML report (C#) — binaries |
| TDPBackup | Backup management for SQL Server with TDP/TSM, one job for every scenario |
- PowerShell 5.1+ — runs on Windows PowerShell 5.1 and PowerShell 7
- GUI and CLI — a WinForms interface for the rare case, the command line for the regular one
- Offline capable — installation and module sideload without internet access, from a UNC path or a local directory
- Multi-domain — built for separated domains with no trust between them
- HTML reporting — every tool produces self-contained HTML reports as evidence
- Built on dbatools — extends the dbatools commands into complete operational processes
These are not lab tools. They run in a strictly regulated, network-segmented large-enterprise environment:
- A four-digit number of SQL Server instances
- A five-digit number of databases
- Many separate security domains with no mutual trust
- Deployment entirely offline
- HTML management reports as operational evidence
Detailed write-ups, screenshots and presentations for the individual tools: powershelldba.de