PsSqlTools is a PowerShell container module that aims to provide specialized and compatible modules that support the professional development of Microsoft SQL solutions in Azure and on-prem.
- PsSqlClient replaces the SQL Server utilities sqlcmd and bcp with native PowerShell commands, based on SqlClient, focused on connections and SQL queries.
- PsSmo replaces the SQL Server utilities sqlcmd with native PowerShell commands, based on SQL Server Management Objects (SMO), focused on SQL script execution and SQL database management.
- PsDac replaces SqlPackage with native PowerShell commands, based on DacFx, focused on database deployment.
| Module | Version | Microsoft.Identity.Client | Microsoft.Data.SqlClient | Microsoft.SqlServer.Smo | Microsoft.SqlServer.Dac |
|---|---|---|---|---|---|
| PsSqlClient | 2.2.0 | 4.47.2.0 | 5.1.1 | ||
| PsSmo | 1.3.0 | 4.47.2.0 | 5.1.1 | 17.100.18 | |
| PsDac | 1.7.0 | 4.48.1.0 | 5.1.1 | 162.1.167 |