tcdbtools
1.0.45
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 Get-DBUserCredential Set-DBUserCredential New-DBUserCredential Write-InformationColorized ConvertTo-Markdown Invoke-Telnet
Dependencies
This module has no dependencies.
Release Notes
1.0.45
* modified Invoke-DBSafeShrink.ps1 so that heaps with bad table design can still be moved
* added #Requires statements to tcdbtools.psm1 so that module will not import without requirements
FileList
- tcdbtools.nuspec
- RELEASE_NOTES
- bin\smo\coreclr\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- bin\smo\coreclr\Microsoft.SqlServer.Types.dll
- tcdbtools.psd1
- bin\smo\coreclr\Microsoft.SqlServer.WmiEnum.dll
- tcdbtools.psm1
- bin\smo\coreclr\Microsoft.SqlServer.XE.Core.dll
- bin\smo\Microsoft.Data.SqlClient.dll
- bin\smo\coreclr\Microsoft.SqlServer.XEvent.Linq.dll
- bin\smo\Microsoft.Data.SqlClient.SNI.x64.dll
- bin\smo\coreclr\Microsoft.SqlServer.XEvent.XELite.dll
- bin\smo\Microsoft.Data.SqlClient.SNI.x86.dll
- bin\smo\coreclr\Microsoft.SqlTools.Hosting.dll
- bin\smo\Microsoft.Data.Tools.Schema.Sql.dll
- bin\smo\coreclr\Microsoft.SqlTools.ManagedBatchParser.dll
- bin\smo\Microsoft.Data.Tools.Sql.BatchParser.dll
- bin\smo\coreclr\sqlpackage
- bin\smo\Microsoft.Data.Tools.Utilities.dll
- bin\smo\coreclr\sqlpackage.dll
- bin\smo\Microsoft.Identity.Client.dll
- bin\smo\coreclr\SqlServer.XEvent.dll
- bin\smo\Microsoft.SqlServer.BatchParser.dll
- bin\smo\coreclr\System.Composition.AttributedModel.dll
- bin\smo\Microsoft.SqlServer.BatchParserClient.dll
- bin\smo\coreclr\System.Composition.Convention.dll
- bin\smo\Microsoft.SqlServer.ConnectionInfo.dll
- bin\smo\coreclr\System.Composition.TypedParts.dll
- bin\smo\Microsoft.SqlServer.Dac.dll
- bin\smo\coreclr\System.Data.SqlClient.dll
- bin\smo\Microsoft.SqlServer.Dac.Extensions.dll
- bin\smo\coreclr\System.Net.Http.dll
- bin\smo\Microsoft.SqlServer.Dmf.Common.dll
- bin\smo\coreclr\System.Resources.Extensions.dll
- bin\smo\Microsoft.SqlServer.Dmf.dll
- bin\smo\coreclr\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.Management.Collector.dll
- bin\smo\coreclr\mac\Azure.Core.dll
- bin\smo\Microsoft.SqlServer.Management.CollectorEnum.dll
- bin\smo\coreclr\mac\Azure.Identity.dll
- bin\smo\Microsoft.SqlServer.Management.Dmf.dll
- bin\smo\coreclr\mac\sqlpackage
- bin\smo\Microsoft.SqlServer.Management.RegisteredServers.dll
- bin\smo\coreclr\mac\System.Memory.Data.dll
- bin\smo\Microsoft.SqlServer.Management.Sdk.Sfc.dll
- bin\smo\coreclr\mac\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.Management.SmoMetadataProvider.dll
- bin\smo\coreclr\win\Azure.Core.dll
- bin\smo\Microsoft.SqlServer.Management.Utility.dll
- bin\smo\coreclr\win\Azure.Identity.dll
- bin\smo\Microsoft.SqlServer.Management.UtilityEnum.dll
- bin\smo\coreclr\win\Microsoft.Build.dll
- bin\smo\Microsoft.SqlServer.Management.XEvent.dll
- bin\smo\coreclr\win\Microsoft.Build.Framework.dll
- bin\smo\Microsoft.SqlServer.Management.XEventDbScoped.dll
- bin\smo\coreclr\win\Microsoft.Data.SqlClient.dll
- bin\smo\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
- bin\smo\coreclr\win\Microsoft.Data.SqlClient.SNI.dll
- bin\smo\Microsoft.SqlServer.Management.XEventEnum.dll
- bin\smo\coreclr\win\Microsoft.Data.Tools.Schema.Sql.dll
- bin\smo\Microsoft.SqlServer.PolicyEnum.dll
- bin\smo\coreclr\win\Microsoft.Data.Tools.Utilities.dll
- bin\smo\Microsoft.SqlServer.RegSvrEnum.dll
- bin\smo\coreclr\win\Microsoft.Identity.Client.dll
- bin\smo\Microsoft.SqlServer.ReplEnum.dll
- bin\smo\coreclr\win\Microsoft.Identity.Client.Extensions.Msal.dll
- bin\smo\Microsoft.SqlServer.Replication.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Dac.dll
- bin\smo\Microsoft.SqlServer.Rmo.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Dac.Extensions.dll
- bin\smo\Microsoft.SqlServer.ServiceBrokerEnum.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- bin\smo\Microsoft.SqlServer.Smo.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Types.dll
- bin\smo\Microsoft.SqlServer.SmoExtended.dll
- bin\smo\coreclr\win\System.Memory.Data.dll
- bin\smo\Microsoft.SqlServer.SqlClrProvider.dll
- bin\smo\coreclr\win\System.Resources.Extensions.dll
- bin\smo\Microsoft.SqlServer.SqlEnum.dll
- bin\smo\coreclr\win\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.SqlTDiagm.dll
- functions\Find-DBColumnDataTypeDiscrepancies.ps1
- bin\smo\Microsoft.SqlServer.SqlWmiManagement.dll
- functions\Find-DBInvalidSettings.ps1
- bin\smo\Microsoft.SqlServer.SString.dll
- functions\Find-DBValue.ps1
- bin\smo\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- functions\Invoke-DBCompareServerSettings.ps1
- bin\smo\Microsoft.SqlServer.Types.dll
- functions\Invoke-DBDeployAgentJob.ps1
- bin\smo\Microsoft.SqlServer.WmiEnum.dll
- functions\Invoke-DBExtractCLRDll.ps1
- bin\smo\Microsoft.SqlServer.XE.Core.dll
- functions\Invoke-DBMoveIndexes.ps1
- bin\smo\Microsoft.SqlServer.XEvent.Linq.dll
- functions\Invoke-DBRenameConstraints.ps1
- bin\smo\Microsoft.SqlServer.XEvent.XELite.dll
- functions\Invoke-DBSafeShrink.ps1
- bin\smo\msvcp120.dll
- functions\Invoke-DBScriptObjects.ps1
- bin\smo\msvcr120.dll
- functions\Invoke-DBSqlAgentScripter.ps1
- bin\smo\Newtonsoft.Json.dll
- functions\Test-DBReadOnlyRouting.ps1
- bin\smo\smo-deps.txt
- functions\Test-DBSqlConnection.ps1
- bin\smo\sqlpackage.exe
- functions\ado\Get-DBInClauseParams.ps1
- bin\smo\sqlpackage.exe.config
- functions\ado\Get-DBInClauseString.ps1
- bin\smo\SqlServer.XEvent.dll
- functions\ado\Invoke-DBDataSetQuery.ps1
- bin\smo\System.Net.Http.dll
- functions\ado\Invoke-DBDataTableQuery.ps1
- bin\smo\coreclr\Azure.Core.dll
- functions\ado\Invoke-DBNonQuery.ps1
- bin\smo\coreclr\Azure.Identity.dll
- functions\ado\Invoke-DBReaderQuery.ps1
- bin\smo\coreclr\Azure.Security.KeyVault.Keys.dll
- functions\ado\Invoke-DBScalarQuery.ps1
- bin\smo\coreclr\Microsoft.Build.dll
- functions\ado\New-DBSqlConnection.ps1
- bin\smo\coreclr\Microsoft.Build.Framework.dll
- functions\ado\New-DBSqlParameter.ps1
- bin\smo\coreclr\Microsoft.Data.SqlClient.dll
- functions\credentials\Get-DBUserCredential.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Schema.Sql.dll
- functions\credentials\Set-DBUserCredential.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Sql.BatchParser.dll
- functions\helpers\Get-AllUserDatabases.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Utilities.dll
- functions\helpers\New-DBScripterObject.ps1
- bin\smo\coreclr\Microsoft.Identity.Client.dll
- functions\helpers\New-DBSMOServer.ps1
- bin\smo\coreclr\Microsoft.Identity.Client.Extensions.Msal.dll
- functions\helpers\New-DBSqlCmdArguments.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.Cmdlets.dll
- functions\misc\ConvertTo-Markdown.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.dll
- functions\misc\Invoke-Telnet.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.Types.dll
- functions\misc\template.ps1
- bin\smo\coreclr\Microsoft.SqlServer.ConnectionInfo.dll
- functions\misc\Write-InformationColorized.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-DBSqlAgentScripter.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.HadrModel.dll
- functions\private\ModuleInit.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.PSProvider.dll
- functions\private\Test-DBReadOnlyRouting.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.PSSnapins.dll
- functions\private\Test-DBSqlConnection.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.RegisteredServers.dll
- sql\AddShrinkTempObjects.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.Sdk.Sfc.dll
- sql\AllUserDatabases.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.SmoMetadataProvider.dll
- sql\FindColumnDataTypeDifferences.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.SqlScriptPublish.dll
- sql\FindInvalidSettings.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEvent.dll
- sql\FindSynchronizedDB.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventDbScoped.dll
- sql\GetAssemblies.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
- sql\GetConstraints.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventEnum.dll
- sql\GetFreeSpace.sql
- bin\smo\coreclr\Microsoft.SqlServer.PolicyEnum.dll
- sql\GetIndexes.sql
- bin\smo\coreclr\Microsoft.SqlServer.ServiceBrokerEnum.dll
- sql\GetServerSettings.sql
- bin\smo\coreclr\Microsoft.SqlServer.Smo.dll
- sql\RemoveShrinkTempObjects.sql
- bin\smo\coreclr\Microsoft.SqlServer.Smo.Notebook.dll
- sql\ScanForValueColumns.sql
- bin\smo\coreclr\Microsoft.SqlServer.SmoExtended.dll
- sql\SqlAgentIfNotExistsDrop.sql
- bin\smo\coreclr\Microsoft.SqlServer.SqlEnum.dll
- sql\SqlAgentJobExample.sql
- bin\smo\coreclr\Microsoft.SqlServer.SqlWmiManagement.dll
- sql\WaitForTsqlAgentJobToStop.sql
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 1.0.45 (current version) | 16 | 3/3/2023 |
| 1.0.44 | 13 | 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 |