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