SqlSizer-MSSQL

1.0.6

A PowerShell module for managing data in Microsoft SQL Server, Azure SQL databases and Azure Synapse Analytics SQL Pool.

Installation Options

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

Install-Module -Name SqlSizer-MSSQL

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

Install-PSResource -Name SqlSizer-MSSQL

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

Copyright

Copyright (c) 2022-2023 Marcin Gołębiowski (licensed under MIT)

Package Details

Author(s)

  • Marcin Gołębiowski

Tags

SQL database T-SQL MSSQL search subset

Cmdlets

Disable-ReachableIndexes Enable-ReachableIndexes Enable-Indexes Disable-Indexes Remove-FoundSubsetsFromDatabase Find-RemovalSubset Clear-SqlSizerSessions Test-FoundSubsetIsEmpty Get-SubsetHashSummary Get-SubsetSchemaJson Import-TableJson Clear-SqlSizerSession Start-SqlSizerSession Update-DatabaseInfo Install-PrimaryKeys Restore-View Remove-View Remove-ForeignKeys Restore-ForeignKeys Remove-Table Get-SqlSizerInfo Invoke-SqlcmdEx Compare-SavedSubsets Get-SavedSubsetTables Remove-SavedSubset Get-SavedSubsets Save-Subset Get-DatabaseSchemaJson Disable-AllTablesTriggers Enable-AllTablesTriggers Edit-ForeignKey Enable-DatabaseTriggers Enable-TableTrigger Enable-TableTriggers Disable-DatabaseTriggers Disable-TableTrigger Disable-TableTriggers Clear-Database Compress-Database Copy-AzDatabase Copy-Constraints Copy-Database Copy-DataFromSubset Copy-FileToDatabase Copy-Functions Copy-Sequences Copy-StoredProcedures Copy-SubsetToAzStorageContainer Copy-SubsetToDatabaseFileSet Copy-UserTypes Disable-ForeignKeys Enable-ForeignKeys Find-ReachableTables Find-Subset Find-UnreachableTables Format-Indexes Get-DatabaseInfo Get-SubsetTableCsv Get-SubsetTableJson Get-SubsetTableRows Get-SubsetTables Get-SubsetTableStatistics Get-SubsetTableXml Get-SubsetUnreachableEdges Import-SubsetFromAzStorageContainer Import-SubsetFromFileSet Initialize-StartSet Install-ForeignKeyIndexes Install-SqlSizer New-DataTableClone New-DataTableFromSubsetTable New-DataTableFromView New-EmptyAzDatabase New-EmptyCompactDatabase New-EmptyDatabase New-SchemaFromDatabase New-SchemaFromSubset New-SqlConnectionInfo Compare-Tables Remove-DataFromFileSet Remove-EmptyTables Remove-FileFromDatabase Remove-Schema Remove-FoundSubsetFromDatabase Test-DatabaseOnline Test-ForeignKeys Test-IgnoredTables Test-Queries Test-SchemaExists Test-TableExists Uninstall-SqlSizer

Dependencies

This module has no dependencies.

FileList

Version History

Version Downloads Last updated
1.0.6 (current version) 471 2/19/2023
1.0.5 8 2/18/2023
1.0.4 7 2/16/2023
1.0.3 15 12/29/2022
1.0.2 8 12/23/2022
1.0.1 13 12/13/2022
1.0.0 13 12/6/2022
1.0.0-gamma8 10 12/4/2022
1.0.0-gamma6 7 12/1/2022
1.0.0-gamma5 6 11/30/2022
1.0.0-gamma4 7 11/28/2022
1.0.0-gamma3 7 11/27/2022
1.0.0-gamma2 5 11/27/2022
1.0.0-gamma1 7 11/24/2022
1.0.0-beta9 9 11/23/2022
1.0.0-beta8 7 11/23/2022
1.0.0-beta7 11 11/17/2022
1.0.0-beta6 16 11/2/2022
1.0.0-beta5 11 10/31/2022
1.0.0-beta4 12 10/29/2022
1.0.0-beta3 12 10/25/2022
1.0.0-beta2 12 10/13/2022
1.0.0-beta1 13 10/6/2022
1.0.0-alpha9 12 9/22/2022
1.0.0-alpha8 11 9/21/2022
1.0.0-alpha7 11 9/20/2022
1.0.0-alpha6 10 9/18/2022
1.0.0-alpha5 10 9/15/2022
1.0.0-alpha4 10 9/5/2022
1.0.0-alpha3 10 9/2/2022
1.0.0-alpha2 10 8/29/2022
1.0.0-alpha16 10 10/3/2022
1.0.0-alpha15 10 10/3/2022
1.0.0-alpha14 10 10/2/2022
1.0.0-alpha13 10 10/1/2022
1.0.0-alpha12 10 9/28/2022
1.0.0-alpha11 18 9/25/2022
1.0.0-alpha10 10 9/24/2022
1.0.0-alpha 22 7/27/2022
Show more