tcdbtools
1.0.46
A collection of SQL Server automation functionality
Installation Options
Author(s)
Tim Cartwright
Copyright
(c) 2022 Tim Cartwright. All rights reserved.
Package Details
Owners
Tags
sqlserver sql dba databases database smo
Functions
Invoke-DBMoveIndexes Invoke-DBSafeShrink Invoke-DBScriptObjects Invoke-DBExtractCLRDLL Invoke-DBCompareServerSettings Invoke-DBRenameConstraints Find-DBInvalidSettings Find-DBValue Test-DBReadOnlyRouting Find-DBColumnDataTypeDiscrepancies Invoke-DBDeployAgentJob Invoke-DBSqlAgentScripter Invoke-DBScalarQuery Invoke-DBNonQuery Invoke-DBReaderQuery Invoke-DBDataSetQuery Invoke-DBDataTableQuery New-DBSqlParameter Get-DBInClauseParams Get-DBInClauseString New-DBScripterObject New-DBSMOServer New-DBSqlCmdArguments New-DBSQLConnection Get-AllUserDatabases Test-DBSqlConnection Invoke-DBScriptRunner Get-DBUserCredential Set-DBUserCredential New-DBUserCredential Write-InformationColorized ConvertTo-Markdown Invoke-Telnet ConvertFrom-DataRows ConvertFrom-DataTable
Dependencies
This module has no dependencies.
Release Notes
https://github.com/D:\a\tcdbtools\tcdbtools/tcdbtools/blob/main/tcdbtools/RELEASE_NOTES
1.0.46
* Added new function Invoke-DBScriptRunner to allow for running a script multithreaded against multiple target servers and databases
* added help docs for credential functions
* added helper functions ConvertFrom-DataRows, and ConvertFrom-DataTable
FileList
- tcdbtools.nuspec
- RELEASE_NOTES
- bin\smo\coreclr\Microsoft.SqlServer.WmiEnum.dll
- bin\smo\coreclr\Microsoft.SqlServer.XE.Core.dll
- tcdbtools.psd1
- bin\smo\coreclr\Microsoft.SqlServer.XEvent.Linq.dll
- tcdbtools.psm1
- bin\smo\coreclr\Microsoft.SqlServer.XEvent.XELite.dll
- bin\smo\Microsoft.Data.SqlClient.dll
- bin\smo\coreclr\Microsoft.SqlTools.Hosting.dll
- bin\smo\Microsoft.Data.SqlClient.SNI.x64.dll
- bin\smo\coreclr\Microsoft.SqlTools.ManagedBatchParser.dll
- bin\smo\Microsoft.Data.SqlClient.SNI.x86.dll
- bin\smo\coreclr\sqlpackage
- bin\smo\Microsoft.Data.Tools.Schema.Sql.dll
- bin\smo\coreclr\sqlpackage.dll
- bin\smo\Microsoft.Data.Tools.Sql.BatchParser.dll
- bin\smo\coreclr\SqlServer.XEvent.dll
- bin\smo\Microsoft.Data.Tools.Utilities.dll
- bin\smo\coreclr\System.Composition.AttributedModel.dll
- bin\smo\Microsoft.Identity.Client.dll
- bin\smo\coreclr\System.Composition.Convention.dll
- bin\smo\Microsoft.SqlServer.BatchParser.dll
- bin\smo\coreclr\System.Composition.TypedParts.dll
- bin\smo\Microsoft.SqlServer.BatchParserClient.dll
- bin\smo\coreclr\System.Data.SqlClient.dll
- bin\smo\Microsoft.SqlServer.ConnectionInfo.dll
- bin\smo\coreclr\System.Net.Http.dll
- bin\smo\Microsoft.SqlServer.Dac.dll
- bin\smo\coreclr\System.Resources.Extensions.dll
- bin\smo\Microsoft.SqlServer.Dac.Extensions.dll
- bin\smo\coreclr\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.Dmf.Common.dll
- bin\smo\coreclr\mac\Azure.Core.dll
- bin\smo\Microsoft.SqlServer.Dmf.dll
- bin\smo\coreclr\mac\Azure.Identity.dll
- bin\smo\Microsoft.SqlServer.Management.Collector.dll
- bin\smo\coreclr\mac\sqlpackage
- bin\smo\Microsoft.SqlServer.Management.CollectorEnum.dll
- bin\smo\coreclr\mac\System.Memory.Data.dll
- bin\smo\Microsoft.SqlServer.Management.Dmf.dll
- bin\smo\coreclr\mac\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.Management.RegisteredServers.dll
- bin\smo\coreclr\win\Azure.Core.dll
- bin\smo\Microsoft.SqlServer.Management.Sdk.Sfc.dll
- bin\smo\coreclr\win\Azure.Identity.dll
- bin\smo\Microsoft.SqlServer.Management.SmoMetadataProvider.dll
- bin\smo\coreclr\win\Microsoft.Build.dll
- bin\smo\Microsoft.SqlServer.Management.Utility.dll
- bin\smo\coreclr\win\Microsoft.Build.Framework.dll
- bin\smo\Microsoft.SqlServer.Management.UtilityEnum.dll
- bin\smo\coreclr\win\Microsoft.Data.SqlClient.dll
- bin\smo\Microsoft.SqlServer.Management.XEvent.dll
- bin\smo\coreclr\win\Microsoft.Data.SqlClient.SNI.dll
- bin\smo\Microsoft.SqlServer.Management.XEventDbScoped.dll
- bin\smo\coreclr\win\Microsoft.Data.Tools.Schema.Sql.dll
- bin\smo\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
- bin\smo\coreclr\win\Microsoft.Data.Tools.Utilities.dll
- bin\smo\Microsoft.SqlServer.Management.XEventEnum.dll
- bin\smo\coreclr\win\Microsoft.Identity.Client.dll
- bin\smo\Microsoft.SqlServer.PolicyEnum.dll
- bin\smo\coreclr\win\Microsoft.Identity.Client.Extensions.Msal.dll
- bin\smo\Microsoft.SqlServer.RegSvrEnum.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Dac.dll
- bin\smo\Microsoft.SqlServer.ReplEnum.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Dac.Extensions.dll
- bin\smo\Microsoft.SqlServer.Replication.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- bin\smo\Microsoft.SqlServer.Rmo.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Types.dll
- bin\smo\Microsoft.SqlServer.ServiceBrokerEnum.dll
- bin\smo\coreclr\win\System.Memory.Data.dll
- bin\smo\Microsoft.SqlServer.Smo.dll
- bin\smo\coreclr\win\System.Resources.Extensions.dll
- bin\smo\Microsoft.SqlServer.SmoExtended.dll
- bin\smo\coreclr\win\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.SqlClrProvider.dll
- functions\Find-DBColumnDataTypeDiscrepancies.ps1
- bin\smo\Microsoft.SqlServer.SqlEnum.dll
- functions\Find-DBInvalidSettings.ps1
- bin\smo\Microsoft.SqlServer.SqlTDiagm.dll
- functions\Find-DBValue.ps1
- bin\smo\Microsoft.SqlServer.SqlWmiManagement.dll
- functions\Invoke-DBCompareServerSettings.ps1
- bin\smo\Microsoft.SqlServer.SString.dll
- functions\Invoke-DBDeployAgentJob.ps1
- bin\smo\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- functions\Invoke-DBExtractCLRDll.ps1
- bin\smo\Microsoft.SqlServer.Types.dll
- functions\Invoke-DBMoveIndexes.ps1
- bin\smo\Microsoft.SqlServer.WmiEnum.dll
- functions\Invoke-DBRenameConstraints.ps1
- bin\smo\Microsoft.SqlServer.XE.Core.dll
- functions\Invoke-DBSafeShrink.ps1
- bin\smo\Microsoft.SqlServer.XEvent.Linq.dll
- functions\Invoke-DBScriptObjects.ps1
- bin\smo\Microsoft.SqlServer.XEvent.XELite.dll
- functions\Invoke-DBScriptRunner.ps1
- bin\smo\msvcp120.dll
- functions\Invoke-DBSqlAgentScripter.ps1
- bin\smo\msvcr120.dll
- functions\Test-DBReadOnlyRouting.ps1
- bin\smo\Newtonsoft.Json.dll
- functions\Test-DBSqlConnection.ps1
- bin\smo\smo-deps.txt
- functions\ado\Get-DBInClauseParams.ps1
- bin\smo\sqlpackage.exe
- functions\ado\Get-DBInClauseString.ps1
- bin\smo\sqlpackage.exe.config
- functions\ado\Invoke-DBDataSetQuery.ps1
- bin\smo\SqlServer.XEvent.dll
- functions\ado\Invoke-DBDataTableQuery.ps1
- bin\smo\System.Net.Http.dll
- functions\ado\Invoke-DBNonQuery.ps1
- bin\smo\coreclr\Azure.Core.dll
- functions\ado\Invoke-DBReaderQuery.ps1
- bin\smo\coreclr\Azure.Identity.dll
- functions\ado\Invoke-DBScalarQuery.ps1
- bin\smo\coreclr\Azure.Security.KeyVault.Keys.dll
- functions\ado\New-DBSqlConnection.ps1
- bin\smo\coreclr\Microsoft.Build.dll
- functions\ado\New-DBSqlParameter.ps1
- bin\smo\coreclr\Microsoft.Build.Framework.dll
- functions\credentials\Get-DBUserCredential.ps1
- bin\smo\coreclr\Microsoft.Data.SqlClient.dll
- functions\credentials\Set-DBUserCredential.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Schema.Sql.dll
- functions\helpers\Get-AllUserDatabases.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Sql.BatchParser.dll
- functions\helpers\New-DBScripterObject.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Utilities.dll
- functions\helpers\New-DBSMOServer.ps1
- bin\smo\coreclr\Microsoft.Identity.Client.dll
- functions\helpers\New-DBSqlCmdArguments.ps1
- bin\smo\coreclr\Microsoft.Identity.Client.Extensions.Msal.dll
- functions\misc\ConvertFrom-DataRows.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.Cmdlets.dll
- functions\misc\ConvertFrom-DataTable.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.dll
- functions\misc\ConvertTo-Markdown.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.Types.dll
- functions\misc\Invoke-Telnet.ps1
- bin\smo\coreclr\Microsoft.SqlServer.ConnectionInfo.dll
- functions\misc\template.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dac.dll
- functions\misc\Write-InformationColorized.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dac.Extensions.dll
- functions\private\Find-DBInvalidSettings.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dmf.Common.dll
- functions\private\Find-DBValue.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dmf.dll
- functions\private\GenFuncs.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.Assessment.dll
- functions\private\Invoke-Credentials.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.Collector.dll
- functions\private\Invoke-DBCompareServerSettings.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.CollectorEnum.dll
- functions\private\Invoke-DBRenameConstraints.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.Dmf.dll
- functions\private\Invoke-DBSafeShrink.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.HadrData.dll
- functions\private\Invoke-DBScriptObjects.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.HadrModel.dll
- functions\private\Invoke-DBScriptRunner.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.PSProvider.dll
- functions\private\Invoke-DBSqlAgentScripter.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.PSSnapins.dll
- functions\private\ModuleInit.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.RegisteredServers.dll
- functions\private\Test-DBReadOnlyRouting.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.Sdk.Sfc.dll
- functions\private\Test-DBSqlConnection.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.SmoMetadataProvider.dll
- sql\AddShrinkTempObjects.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.SqlScriptPublish.dll
- sql\AllUserDatabases.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEvent.dll
- sql\FindColumnDataTypeDifferences.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventDbScoped.dll
- sql\FindInvalidSettings.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
- sql\FindSynchronizedDB.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventEnum.dll
- sql\GetAssemblies.sql
- bin\smo\coreclr\Microsoft.SqlServer.PolicyEnum.dll
- sql\GetConstraints.sql
- bin\smo\coreclr\Microsoft.SqlServer.ServiceBrokerEnum.dll
- sql\GetFreeSpace.sql
- bin\smo\coreclr\Microsoft.SqlServer.Smo.dll
- sql\GetIndexes.sql
- bin\smo\coreclr\Microsoft.SqlServer.Smo.Notebook.dll
- sql\GetServerSettings.sql
- bin\smo\coreclr\Microsoft.SqlServer.SmoExtended.dll
- sql\RemoveShrinkTempObjects.sql
- bin\smo\coreclr\Microsoft.SqlServer.SqlEnum.dll
- sql\ScanForValueColumns.sql
- bin\smo\coreclr\Microsoft.SqlServer.SqlWmiManagement.dll
- sql\SqlAgentIfNotExistsDrop.sql
- bin\smo\coreclr\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- sql\SqlAgentJobExample.sql
- bin\smo\coreclr\Microsoft.SqlServer.Types.dll
- sql\WaitForTsqlAgentJobToStop.sql
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 1.0.50 | 5 | 5/29/2023 |
| 1.0.49 | 22 | 5/17/2023 |
| 1.0.48 | 8 | 5/8/2023 |
| 1.0.47 | 15 | 4/20/2023 |
| 1.0.46 (current version) | 17 | 3/28/2023 |
| 1.0.45 | 23 | 3/3/2023 |
| 1.0.44 | 14 | 2/28/2023 |
| 1.0.43 | 22 | 2/15/2023 |
| 1.0.42 | 18 | 2/10/2023 |
| 1.0.41 | 20 | 2/2/2023 |
| 1.0.40 | 7 | 1/25/2023 |
| 1.0.39 | 11 | 1/25/2023 |
| 1.0.38 | 11 | 1/25/2023 |
| 1.0.37 | 6 | 1/25/2023 |
| 1.0.36 | 9 | 1/18/2023 |
| 1.0.35 | 4 | 1/18/2023 |
| 1.0.34 | 4 | 1/17/2023 |
| 1.0.33 | 4 | 1/14/2023 |
| 1.0.32 | 5 | 1/13/2023 |
| 1.0.31 | 5 | 1/11/2023 |
| 1.0.30 | 8 | 1/9/2023 |
| 1.0.29 | 5 | 1/5/2023 |
| 1.0.28 | 7 | 12/23/2022 |
| 1.0.27 | 4 | 12/22/2022 |
| 1.0.26 | 4 | 12/22/2022 |
| 1.0.25 | 6 | 12/21/2022 |
| 1.0.24 | 5 | 12/21/2022 |
| 1.0.23 | 6 | 12/21/2022 |
| 1.0.22 | 4 | 12/21/2022 |
| 1.0.21 | 5 | 12/20/2022 |
| 1.0.20 | 5 | 12/20/2022 |
| 1.0.19 | 4 | 12/20/2022 |
| 1.0.18 | 5 | 12/16/2022 |
| 1.0.17 | 3 | 12/16/2022 |
| 1.0.16 | 4 | 12/16/2022 |
| 1.0.15 | 4 | 12/16/2022 |
| 1.0.14 | 5 | 12/16/2022 |
| 1.0.13 | 9 | 12/13/2022 |
| 1.0.12 | 4 | 12/13/2022 |
| 1.0.11 | 5 | 12/12/2022 |
| 1.0.10 | 5 | 12/12/2022 |
| 1.0.9 | 5 | 12/12/2022 |
| 1.0.8 | 5 | 12/12/2022 |
| 1.0.7 | 7 | 12/9/2022 |
| 1.0.6 | 5 | 12/9/2022 |
| 1.0.5 | 4 | 12/9/2022 |
| 1.0.4 | 4 | 12/9/2022 |
| 1.0.3 | 3 | 12/9/2022 |
| 1.0.1 | 4 | 12/9/2022 |
| 1.0.0 | 6 | 12/9/2022 |