SqlSizer-MSSQL

1.0.0-alpha6

A set of PowerShell scripts to make subsets of the data from Microsoft SQL database

This is a prerelease version of SqlSizer-MSSQL.
There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

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

Install-Module -Name SqlSizer-MSSQL -RequiredVersion 1.0.0-alpha6 -AllowPrerelease

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

Install-PSResource -Name SqlSizer-MSSQL -Version 1.0.0-alpha6 -Prerelease

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 Marcin Gołębiowski (licensed under MIT)

Package Details

Author(s)

  • Marcin Gołębiowski

Tags

SQL database T-SQL MSSQL search subset

Cmdlets

Invoke-SqlcmdEx Compare-SavedSubsets Get-SavedSubsetTables Remove-SavedSubset Get-SavedSubsets Save-Subset New-DatabaseSchemaJson Disable-AllTablesTriggers Enable-AllTablesTriggers Edit-IntegrityCheck Enable-DatabaseTriggers Enable-TableTrigger Enable-TableTriggers Disable-DatabaseTriggers Disable-TableTrigger Disable-TableTriggers Clear-Database Clear-SqlSizer 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-IntegrityChecks Enable-IntegrityChecks 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 New-TableCompare Remove-DataFromFileSet Remove-EmptyTables Remove-FileFromDatabase Remove-Schema Remove-SubsetData 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 845 2/19/2023
1.0.5 9 2/18/2023
1.0.4 9 2/16/2023
1.0.3 20 12/29/2022
1.0.2 14 12/23/2022
1.0.1 19 12/13/2022
1.0.0 20 12/6/2022
1.0.0-gamma8 15 12/4/2022
1.0.0-gamma6 12 12/1/2022
1.0.0-gamma5 12 11/30/2022
1.0.0-gamma4 13 11/28/2022
1.0.0-gamma3 12 11/27/2022
1.0.0-gamma2 10 11/27/2022
1.0.0-gamma1 12 11/24/2022
1.0.0-beta9 14 11/23/2022
1.0.0-beta8 13 11/23/2022
1.0.0-beta7 17 11/17/2022
1.0.0-beta6 22 11/2/2022
1.0.0-beta5 17 10/31/2022
1.0.0-beta4 17 10/29/2022
1.0.0-beta3 18 10/25/2022
1.0.0-beta2 18 10/13/2022
1.0.0-beta1 19 10/6/2022
1.0.0-alpha9 17 9/22/2022
1.0.0-alpha8 17 9/21/2022
1.0.0-alpha7 16 9/20/2022
1.0.0-alpha6 (current version) 17 9/18/2022
1.0.0-alpha5 17 9/15/2022
1.0.0-alpha4 16 9/5/2022
1.0.0-alpha3 16 9/2/2022
1.0.0-alpha2 17 8/29/2022
1.0.0-alpha16 16 10/3/2022
1.0.0-alpha15 16 10/3/2022
1.0.0-alpha14 16 10/2/2022
1.0.0-alpha13 16 10/1/2022
1.0.0-alpha12 18 9/28/2022
1.0.0-alpha11 24 9/25/2022
1.0.0-alpha10 16 9/24/2022
1.0.0-alpha 27 7/27/2022
Show less