SqlSizer-MSSQL

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

Installation Options

Owners

• marcin.golebiowski

Copyright

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

Package Details

FileList

• SqlSizer-MSSQL.nuspec
• Public\Import-SubsetFromAzStorageContainer.ps1
• LICENSE
• Public\Import-SubsetFromFileSet.ps1
• Public\Import-TableJson.ps1
• SqlSizer-MSSQL.psd1
• Public\Initialize-StartSet.ps1
• SqlSizer-MSSQL.psm1
• Public\Install-ForeignKeyIndexes.ps1
• Public\Clear-Database.ps1
• Public\Install-PrimaryKeys.ps1
• Public\Clear-SqlSizerSession.ps1
• Public\Install-SqlSizer.ps1
• Public\Clear-SqlSizerSessions.ps1
• Public\Install-SqlSizerCore.ps1
• Public\Compare-SavedSubsets.ps1
• Public\Install-SqlSizerExportViews.ps1
• Public\Compare-Tables.ps1
• Public\Install-SqlSizerResultViews.ps1
• Public\Compress-Database.ps1
• Public\Install-SqlSizerSecureViews.ps1
• Public\Copy-AzDatabase.ps1
• Public\Install-SqlSizerSessionTables.ps1
• Public\Copy-Constraints.ps1
• Public\Invoke-SqlcmdEx.ps1
• Public\Copy-Database.ps1
• Public\New-DataTableClone.ps1
• Public\Copy-DataFromSubset.ps1
• Public\New-DataTableFromSubsetTable.ps1
• Public\Copy-FileToDatabase.ps1
• Public\New-DataTableFromView.ps1
• Public\Copy-Functions.ps1
• Public\New-EmptyAzDatabase.ps1
• Public\Copy-Sequences.ps1
• Public\New-EmptyCompactDatabase.ps1
• Public\Copy-StoredProcedures.ps1
• Public\New-EmptyDatabase.ps1
• Public\Copy-SubsetToAzStorageContainer.ps1
• Public\New-ForeignKey.ps1
• Public\Copy-SubsetToDatabaseFileSet.ps1
• Public\New-SchemaFromDatabase.ps1
• Public\Copy-UserTypes.ps1
• Public\New-SchemaFromSubset.ps1
• Public\Disable-AllTablesTriggers.ps1
• Public\New-SqlConnectionInfo.ps1
• Public\Disable-DatabaseTriggers.ps1
• Public\Remove-DataFromFileSet.ps1
• Public\Disable-ForeignKeys.ps1
• Public\Remove-EmptyTables.ps1
• Public\Disable-Indexes.ps1
• Public\Remove-FileFromDatabase.ps1
• Public\Disable-ReachableIndexes.ps1
• Public\Remove-ForeignKeys.ps1
• Public\Disable-TableTrigger.ps1
• Public\Remove-FoundSubsetFromDatabase.ps1
• Public\Disable-TableTriggers.ps1
• Public\Remove-FoundSubsetsFromDatabase.ps1
• Public\Edit-ForeignKey.ps1
• Public\Remove-SavedSubset.ps1
• Public\Enable-AllTablesTriggers.ps1
• Public\Remove-Schema.ps1
• Public\Enable-DatabaseTriggers.ps1
• Public\Remove-Table.ps1
• Public\Enable-ForeignKeys.ps1
• Public\Remove-View.ps1
• Public\Enable-Indexes.ps1
• Public\Restore-ForeignKeys.ps1
• Public\Enable-ReachableIndexes.ps1
• Public\Restore-View.ps1
• Public\Enable-TableTrigger.ps1
• Public\Save-Subset.ps1
• Public\Enable-TableTriggers.ps1
• Public\Start-SqlSizerSession.ps1
• Public\Find-ReachableTables.ps1
• Public\Test-DatabaseOnline.ps1
• Public\Find-RemovalSubset.ps1
• Public\Test-ForeignKeys.ps1
• Public\Find-Subset.ps1
• Public\Test-FoundSubsetIsEmpty.ps1
• Public\Find-UnreachableTables.ps1
• Public\Test-IgnoredTables.ps1
• Public\Format-Indexes.ps1
• Public\Test-Queries.ps1
• Public\Get-DatabaseInfo.ps1
• Public\Test-SchemaExists.ps1
• Public\Get-DatabaseSchemaJson.ps1
• Public\Test-TableExists.ps1
• Public\Get-SavedSubsets.ps1
• Public\Uninstall-SqlSizer.ps1
• Public\Get-SavedSubsetTables.ps1
• Public\Update-DatabaseInfo.ps1
• Public\Get-SqlSizerInfo.ps1
• Shared\Get-ColumnValue.ps1
• Public\Get-SubsetHashSummary.ps1
• Shared\Get-FkRule.ps1
• Public\Get-SubsetSchemaJson.ps1
• Shared\Get-LogicalReadsValue.ps1
• Public\Get-SubsetTableCsv.ps1
• Shared\Get-Prefix.ps1
• Public\Get-SubsetTableJson.ps1
• Shared\Get-SubsetProgress.ps1
• Public\Get-SubsetTableRows.ps1
• Shared\Get-TableSelect.ps1
• Public\Get-SubsetTables.ps1
• Shared\Initialize-OperationsTable.ps1
• Public\Get-SubsetTableStatistics.ps1
• Types\SqlSizer-MSSQL-Types.ps1
• Public\Get-SubsetTableXml.ps1
• Public\Get-SubsetUnreachableEdges.ps1

Version History