tcdbtools

1.0.42

A collection of SQL Server automation functionality

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name tcdbtools -RequiredVersion 1.0.42

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name tcdbtools -Version 1.0.42

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

tcartwright

Copyright

Package Details

Author(s)

Tim Cartwright

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 Get-DBUserCredential Set-DBUserCredential New-DBUserCredential Write-InformationColorized ConvertTo-Markdown

Dependencies

This module has no dependencies.

Release Notes

1.0.42
* Added new parameters to the Invoke-DBMoveIndexes function to allow for more control of what it moved:
* ExcludeIndexes
* IncludeIndexes
* ExcludeTables
* IncludeTables
* ExcludeSchemas
* IncludeSchemas

FileList

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

Version History

Version	Downloads	Last updated
1.0.54	786	8/11/2023
1.0.53	44	6/10/2023
1.0.52	11	6/9/2023
1.0.51	9	6/9/2023
1.0.50	16	5/29/2023
1.0.49	28	5/17/2023
1.0.48	14	5/8/2023
1.0.47	21	4/20/2023
1.0.46	23	3/28/2023
1.0.45	30	3/3/2023
1.0.44	20	2/28/2023
1.0.43	28	2/15/2023
1.0.42 (current version)	23	2/10/2023
1.0.41	30	2/2/2023
1.0.40	17	1/25/2023
1.0.39	21	1/25/2023
1.0.38	22	1/25/2023
1.0.37	16	1/25/2023
1.0.36	19	1/18/2023
1.0.35	14	1/18/2023
1.0.34	14	1/17/2023
1.0.33	14	1/14/2023
1.0.32	15	1/13/2023
1.0.31	15	1/11/2023
1.0.30	18	1/9/2023
1.0.29	15	1/5/2023
1.0.28	17	12/23/2022
1.0.27	14	12/22/2022
1.0.26	14	12/22/2022
1.0.25	16	12/21/2022
1.0.24	15	12/21/2022
1.0.23	16	12/21/2022
1.0.22	14	12/21/2022
1.0.21	15	12/20/2022
1.0.20	15	12/20/2022
1.0.19	14	12/20/2022
1.0.18	15	12/16/2022
1.0.17	13	12/16/2022
1.0.16	15	12/16/2022
1.0.15	15	12/16/2022
1.0.14	15	12/16/2022
1.0.13	20	12/13/2022
1.0.12	14	12/13/2022
1.0.11	15	12/12/2022
1.0.10	14	12/12/2022
1.0.9	15	12/12/2022
1.0.8	16	12/12/2022
1.0.7	17	12/9/2022
1.0.6	15	12/9/2022
1.0.5	14	12/9/2022
1.0.4	14	12/9/2022
1.0.3	13	12/9/2022
1.0.1	14	12/9/2022
1.0.0	16	12/9/2022

Show less