SMO | dbatools | Command-line superpowers for SQL Server automation

Get-DbaManagementObject

Ben Miller (@DBAduck), dbaduck.com

Get-DbaManagementObject View Source Ben Miller (@DBAduck), dbaduck.com Windows, Linux, macOS Synopsis Discovers installed SQL Server Management Object (SMO) assemblies and their load status Description Scans the system for SQL Server Management Object (SMO) assemblies, SqlClient libraries, and SNI modules to help troubleshoot version conflicts and connectivity issues. This function checks both the Global Assembly Cache (GAC) and currently loaded assemblies in the PowerShell session, returning version information, load status, file paths, and ready-to-use Add-Type commands.

Test-DbaManagementObject

Ben Miller (@DBAduck), dbaduck.com

Test-DbaManagementObject View Source Ben Miller (@DBAduck), dbaduck.com Windows, Linux, macOS Synopsis Verifies if specific SQL Server Management Objects (SMO) library versions are installed on target computers. Description Checks the Global Assembly Cache (GAC) for Microsoft.SqlServer.Smo assemblies of specified versions. This function helps DBAs ensure the required SMO libraries are available before executing scripts that depend on specific SQL Server client tool versions. Returns detailed results showing which versions exist on each target computer, preventing runtime errors when SMO-dependent automation runs against systems with missing or incompatible client libraries.