tcdbtools
1.0.35
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 Write-InformationColorized New-DBScripterObject New-DBSMOServer New-DBSqlCmdArguments New-DBSQLConnection
Dependencies
This module has no dependencies.
FileList
- tcdbtools.nuspec
- bin\smo\coreclr\Microsoft.SqlServer.PolicyEnum.dll
- bin\smo\coreclr\Microsoft.SqlServer.ServiceBrokerEnum.dll
- tcdbtools.psd1
- bin\smo\coreclr\Microsoft.SqlServer.Smo.dll
- tcdbtools.psm1
- bin\smo\coreclr\Microsoft.SqlServer.Smo.Notebook.dll
- bin\smo\Microsoft.Data.SqlClient.dll
- bin\smo\coreclr\Microsoft.SqlServer.SmoExtended.dll
- bin\smo\Microsoft.Data.SqlClient.SNI.x64.dll
- bin\smo\coreclr\Microsoft.SqlServer.SqlEnum.dll
- bin\smo\Microsoft.Data.SqlClient.SNI.x86.dll
- bin\smo\coreclr\Microsoft.SqlServer.SqlWmiManagement.dll
- bin\smo\Microsoft.Data.Tools.Schema.Sql.dll
- bin\smo\coreclr\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- bin\smo\Microsoft.Data.Tools.Sql.BatchParser.dll
- bin\smo\coreclr\Microsoft.SqlServer.Types.dll
- bin\smo\Microsoft.Data.Tools.Utilities.dll
- bin\smo\coreclr\Microsoft.SqlServer.WmiEnum.dll
- bin\smo\Microsoft.Identity.Client.dll
- bin\smo\coreclr\Microsoft.SqlServer.XE.Core.dll
- bin\smo\Microsoft.SqlServer.BatchParser.dll
- bin\smo\coreclr\Microsoft.SqlServer.XEvent.Linq.dll
- bin\smo\Microsoft.SqlServer.BatchParserClient.dll
- bin\smo\coreclr\Microsoft.SqlServer.XEvent.XELite.dll
- bin\smo\Microsoft.SqlServer.ConnectionInfo.dll
- bin\smo\coreclr\Microsoft.SqlTools.Hosting.dll
- bin\smo\Microsoft.SqlServer.Dac.dll
- bin\smo\coreclr\Microsoft.SqlTools.ManagedBatchParser.dll
- bin\smo\Microsoft.SqlServer.Dac.Extensions.dll
- bin\smo\coreclr\sqlpackage
- bin\smo\Microsoft.SqlServer.Dmf.Common.dll
- bin\smo\coreclr\sqlpackage.dll
- bin\smo\Microsoft.SqlServer.Dmf.dll
- bin\smo\coreclr\SqlServer.XEvent.dll
- bin\smo\Microsoft.SqlServer.Management.Collector.dll
- bin\smo\coreclr\System.Composition.AttributedModel.dll
- bin\smo\Microsoft.SqlServer.Management.CollectorEnum.dll
- bin\smo\coreclr\System.Composition.Convention.dll
- bin\smo\Microsoft.SqlServer.Management.Dmf.dll
- bin\smo\coreclr\System.Composition.TypedParts.dll
- bin\smo\Microsoft.SqlServer.Management.RegisteredServers.dll
- bin\smo\coreclr\System.Data.SqlClient.dll
- bin\smo\Microsoft.SqlServer.Management.Sdk.Sfc.dll
- bin\smo\coreclr\System.Net.Http.dll
- bin\smo\Microsoft.SqlServer.Management.SmoMetadataProvider.dll
- bin\smo\coreclr\System.Resources.Extensions.dll
- bin\smo\Microsoft.SqlServer.Management.Utility.dll
- bin\smo\coreclr\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.Management.UtilityEnum.dll
- bin\smo\coreclr\mac\Azure.Core.dll
- bin\smo\Microsoft.SqlServer.Management.XEvent.dll
- bin\smo\coreclr\mac\Azure.Identity.dll
- bin\smo\Microsoft.SqlServer.Management.XEventDbScoped.dll
- bin\smo\coreclr\mac\sqlpackage
- bin\smo\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
- bin\smo\coreclr\mac\System.Memory.Data.dll
- bin\smo\Microsoft.SqlServer.Management.XEventEnum.dll
- bin\smo\coreclr\mac\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.PolicyEnum.dll
- bin\smo\coreclr\win\Azure.Core.dll
- bin\smo\Microsoft.SqlServer.RegSvrEnum.dll
- bin\smo\coreclr\win\Azure.Identity.dll
- bin\smo\Microsoft.SqlServer.ReplEnum.dll
- bin\smo\coreclr\win\Microsoft.Build.dll
- bin\smo\Microsoft.SqlServer.Replication.dll
- bin\smo\coreclr\win\Microsoft.Build.Framework.dll
- bin\smo\Microsoft.SqlServer.Rmo.dll
- bin\smo\coreclr\win\Microsoft.Data.SqlClient.dll
- bin\smo\Microsoft.SqlServer.ServiceBrokerEnum.dll
- bin\smo\coreclr\win\Microsoft.Data.SqlClient.SNI.dll
- bin\smo\Microsoft.SqlServer.Smo.dll
- bin\smo\coreclr\win\Microsoft.Data.Tools.Schema.Sql.dll
- bin\smo\Microsoft.SqlServer.SmoExtended.dll
- bin\smo\coreclr\win\Microsoft.Data.Tools.Utilities.dll
- bin\smo\Microsoft.SqlServer.SqlClrProvider.dll
- bin\smo\coreclr\win\Microsoft.Identity.Client.dll
- bin\smo\Microsoft.SqlServer.SqlEnum.dll
- bin\smo\coreclr\win\Microsoft.Identity.Client.Extensions.Msal.dll
- bin\smo\Microsoft.SqlServer.SqlTDiagm.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Dac.dll
- bin\smo\Microsoft.SqlServer.SqlWmiManagement.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Dac.Extensions.dll
- bin\smo\Microsoft.SqlServer.SString.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- bin\smo\Microsoft.SqlServer.TransactSql.ScriptDom.dll
- bin\smo\coreclr\win\Microsoft.SqlServer.Types.dll
- bin\smo\Microsoft.SqlServer.Types.dll
- bin\smo\coreclr\win\System.Memory.Data.dll
- bin\smo\Microsoft.SqlServer.WmiEnum.dll
- bin\smo\coreclr\win\System.Resources.Extensions.dll
- bin\smo\Microsoft.SqlServer.XE.Core.dll
- bin\smo\coreclr\win\System.Security.SecureString.dll
- bin\smo\Microsoft.SqlServer.XEvent.Linq.dll
- functions\Find-DBColumnDataTypeDiscrepancies.ps1
- bin\smo\Microsoft.SqlServer.XEvent.XELite.dll
- functions\Find-DBInvalidSettings.ps1
- bin\smo\msvcp120.dll
- functions\Find-DBValue.ps1
- bin\smo\msvcr120.dll
- functions\Invoke-DBCompareServerSettings.ps1
- bin\smo\Newtonsoft.Json.dll
- functions\Invoke-DBDeployAgentJob.ps1
- bin\smo\smo-deps.txt
- functions\Invoke-DBExtractCLRDll.ps1
- bin\smo\sqlpackage.exe
- functions\Invoke-DBMoveIndexes.ps1
- bin\smo\sqlpackage.exe.config
- functions\Invoke-DBRenameConstraints.ps1
- bin\smo\SqlServer.XEvent.dll
- functions\Invoke-DBSafeShrink.ps1
- bin\smo\System.Net.Http.dll
- functions\Invoke-DBScriptObjects.ps1
- bin\smo\coreclr\Azure.Core.dll
- functions\Invoke-DBSqlAgentScripter.ps1
- bin\smo\coreclr\Azure.Identity.dll
- functions\Invoke-SqlQueries.ps1
- bin\smo\coreclr\Azure.Security.KeyVault.Keys.dll
- functions\Invoke-Telnet.ps1
- bin\smo\coreclr\Microsoft.Build.dll
- functions\New-DBScripterObject.ps1
- bin\smo\coreclr\Microsoft.Build.Framework.dll
- functions\New-DBSMOServer.ps1
- bin\smo\coreclr\Microsoft.Data.SqlClient.dll
- functions\New-DBSqlCmdArguments.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Schema.Sql.dll
- functions\New-DBSqlConnection.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Sql.BatchParser.dll
- functions\template.ps1
- bin\smo\coreclr\Microsoft.Data.Tools.Utilities.dll
- functions\Test-DBReadOnlyRouting.ps1
- bin\smo\coreclr\Microsoft.Identity.Client.dll
- functions\private\Find-DBInvalidSettings.ps1
- bin\smo\coreclr\Microsoft.Identity.Client.Extensions.Msal.dll
- functions\private\Find-DBValue.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.Cmdlets.dll
- functions\private\GenFuncs.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.dll
- functions\private\Invoke-DBCompareServerSettings.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Assessment.Types.dll
- functions\private\Invoke-DBRenameConstraints.ps1
- bin\smo\coreclr\Microsoft.SqlServer.ConnectionInfo.dll
- functions\private\Invoke-DBSafeShrink.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dac.dll
- functions\private\Invoke-DBScriptObjects.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dac.Extensions.dll
- functions\private\Invoke-DBSqlAgentScripter.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dmf.Common.dll
- functions\private\ModuleInit.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Dmf.dll
- functions\private\Test-DBReadOnlyRouting.ps1
- bin\smo\coreclr\Microsoft.SqlServer.Management.Assessment.dll
- sql\AddShrinkTempObjects.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.Collector.dll
- sql\FindColumnDataTypeDifferences.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.CollectorEnum.dll
- sql\FindInvalidSettings.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.Dmf.dll
- sql\FindSynchronizedDB.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.HadrData.dll
- sql\GetAssemblies.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.HadrModel.dll
- sql\GetConstraints.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.PSProvider.dll
- sql\GetFreeSpace.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.PSSnapins.dll
- sql\GetIndexes.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.RegisteredServers.dll
- sql\GetServerSettings.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.Sdk.Sfc.dll
- sql\RemoveShrinkTempObjects.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.SmoMetadataProvider.dll
- sql\ScanForValueColumns.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.SqlScriptPublish.dll
- sql\SqlAgentIfNotExistsDrop.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEvent.dll
- sql\SqlAgentJobExample.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventDbScoped.dll
- sql\WaitForTsqlAgentJobToStop.sql
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
- bin\smo\coreclr\Microsoft.SqlServer.Management.XEventEnum.dll
Version History
Version | Downloads | Last updated |
---|---|---|
1.0.54 | 500 | 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 (current version) | 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 |