SEARCH:
CleanCode PowerShell Libraries v1.2.08 API: CleanCode » SqlTools
Tools for creating and populating SQL Server tables with PowerShell data.
This module provides cmdlets for writing data to SQL Server databases. Out-DataTable, Add-SqlTable, and Write-DataTable (adapted from Chad Miller's original code) provide the foundation. Those three functions in sequence allow you to send Powershell data into a SQL Server table. Out-SqlTable is a wrapper that combines the three for convenience.
Building upon Invoke-Sqlcmd's notion of default context, Invoke-InferredSqlcmd extends it to work even if you are on a non-SQL Server drive. Get-DBPathInfo and Update-DBEnvironment are used by the other cmdlets on this page to identify this default context and are exposed here for your use as well.
| Add-SqlTable | Creates a SQL Server table from a DataTable. |
| Get-DBPathInfo | Infer values for server and database from SQLSERVER: drive. |
| Invoke-InferredSqlcmd | Executes Invoke-Sqlcmd while attempting to supply a default context. |
| Out-DataTable | Creates a DataTable for an object. |
| Out-SqlTable | Creates a SQL Server table from Powershell objects. |
| Update-DBEnvironment | Infer values for server and database into reference variables. |
| Write-DataTable | Writes data to a SQL Server table. |
This documentation set was created with CleanCode's DocTreeGenerator.
