tcdbtools
1.0.54
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
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) | 54 | 8/11/2023 |
1.0.53 | 38 | 6/10/2023 |
1.0.52 | 5 | 6/9/2023 |
1.0.51 | 3 | 6/9/2023 |
1.0.50 | 10 | 5/29/2023 |
1.0.49 | 23 | 5/17/2023 |
1.0.48 | 8 | 5/8/2023 |
1.0.47 | 15 | 4/20/2023 |
1.0.46 | 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 |