Az.Sql

1.8.0

Microsoft Azure PowerShell - SQL service cmdlets for Azure Resource Manager in Windows PowerShell and PowerShell Core.

For more information on SQL, please visit the following: https://docs.microsoft.com/azure/sql-database/

Minimum PowerShell version

5.1

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 Az.Sql -RequiredVersion 1.8.0

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

Install-PSResource -Name Az.Sql -Version 1.8.0

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

Microsoft Corporation. All rights reserved.

Package Details

Author(s)

  • Microsoft Corporation

Tags

Azure ResourceManager ARM Sql Database

Cmdlets

Get-AzSqlDatabaseTransparentDataEncryption Get-AzSqlDatabaseTransparentDataEncryptionActivity Set-AzSqlDatabaseTransparentDataEncryption Get-AzSqlDatabaseUpgradeHint Get-AzSqlServerUpgradeHint Get-AzSqlServerServiceObjective Get-AzSqlServerActiveDirectoryAdministrator Remove-AzSqlServerActiveDirectoryAdministrator Set-AzSqlServerActiveDirectoryAdministrator Get-AzSqlServer New-AzSqlServer Remove-AzSqlServer Set-AzSqlServer Get-AzSqlServerCommunicationLink New-AzSqlServerCommunicationLink Remove-AzSqlServerCommunicationLink Get-AzSqlDatabaseSecureConnectionPolicy Get-AzSqlDatabaseReplicationLink New-AzSqlDatabaseCopy New-AzSqlDatabaseSecondary Remove-AzSqlDatabaseSecondary Set-AzSqlDatabaseSecondary Get-AzSqlElasticPoolRecommendation Get-AzSqlDatabaseIndexRecommendations Start-AzSqlDatabaseExecuteIndexRecommendation Stop-AzSqlDatabaseExecuteIndexRecommendation Get-AzSqlServerFirewallRule New-AzSqlServerFirewallRule Remove-AzSqlServerFirewallRule Set-AzSqlServerFirewallRule Get-AzSqlElasticPool Get-AzSqlElasticPoolActivity Get-AzSqlElasticPoolDatabase New-AzSqlElasticPool Remove-AzSqlElasticPool Set-AzSqlElasticPool Get-AzSqlServerDisasterRecoveryConfiguration Get-AzSqlServerDisasterRecoveryConfigurationActivity New-AzSqlServerDisasterRecoveryConfiguration Remove-AzSqlServerDisasterRecoveryConfiguration Set-AzSqlServerDisasterRecoveryConfiguration Resume-AzSqlDatabase Suspend-AzSqlDatabase Get-AzSqlDatabaseDataMaskingPolicy Get-AzSqlDatabaseDataMaskingRule New-AzSqlDatabaseDataMaskingRule Remove-AzSqlDatabaseDataMaskingRule Set-AzSqlDatabaseDataMaskingPolicy Set-AzSqlDatabaseDataMaskingRule Get-AzSqlCapability Get-AzSqlServerThreatDetectionPolicy Remove-AzSqlServerThreatDetectionPolicy Set-AzSqlServerThreatDetectionPolicy Get-AzSqlDatabaseThreatDetectionPolicy Set-AzSqlDatabaseThreatDetectionPolicy Remove-AzSqlDatabaseThreatDetectionPolicy Get-AzSqlDatabase Get-AzSqlDatabaseActivity Get-AzSqlDatabaseExpanded New-AzSqlDatabase Remove-AzSqlDatabase Set-AzSqlDatabase Get-AzSqlDatabaseImportExportStatus New-AzSqlDatabaseExport New-AzSqlDatabaseImport Get-AzSqlDatabaseGeoBackupPolicy Set-AzSqlDatabaseGeoBackupPolicy Get-AzSqlDatabaseBackupShortTermRetentionPolicy Set-AzSqlDatabaseBackupShortTermRetentionPolicy Get-AzSqlDatabaseBackupLongTermRetentionPolicy Set-AzSqlDatabaseBackupLongTermRetentionPolicy Get-AzSqlDatabaseLongTermRetentionBackup Remove-AzSqlDatabaseLongTermRetentionBackup Get-AzSqlDeletedDatabaseBackup Get-AzSqlDatabaseGeoBackup Restore-AzSqlDatabase Get-AzSqlDatabaseRestorePoints Get-AzSqlDatabaseAuditing Get-AzSqlServerAuditing Set-AzSqlDatabaseAuditing Set-AzSqlServerAuditing Get-AzSqlDatabaseRecommendedAction Get-AzSqlElasticPoolRecommendedAction Get-AzSqlServerRecommendedAction Set-AzSqlDatabaseRecommendedActionState Set-AzSqlElasticPoolRecommendedActionState Set-AzSqlServerRecommendedActionState Get-AzSqlElasticPoolAdvisor Get-AzSqlServerAdvisor Set-AzSqlElasticPoolAdvisorAutoExecuteStatus Set-AzSqlServerAdvisorAutoExecuteStatus Get-AzSqlDatabaseAdvisor Set-AzSqlDatabaseAdvisorAutoExecuteStatus Get-AzSqlServerTransparentDataEncryptionProtector Set-AzSqlServerTransparentDataEncryptionProtector Add-AzSqlServerKeyVaultKey Get-AzSqlServerKeyVaultKey Remove-AzSqlServerKeyVaultKey Get-AzSqlDatabaseFailoverGroup New-AzSqlDatabaseFailoverGroup Add-AzSqlDatabaseToFailoverGroup Remove-AzSqlDatabaseFromFailoverGroup Remove-AzSqlDatabaseFailoverGroup Set-AzSqlDatabaseFailoverGroup Switch-AzSqlDatabaseFailoverGroup New-AzSqlSyncGroup Update-AzSqlSyncGroup Get-AzSqlSyncGroup Get-AzSqlSyncGroupLog Remove-AzSqlSyncGroup Update-AzSqlSyncSchema Get-AzSqlSyncSchema Start-AzSqlSyncGroupSync Stop-AzSqlSyncGroupSync New-AzSqlSyncMember Update-AzSqlSyncMember Get-AzSqlSyncMember Remove-AzSqlSyncMember New-AzSqlSyncAgent Get-AzSqlSyncAgent Remove-AzSqlSyncAgent New-AzSqlSyncAgentKey Get-AzSqlSyncAgentLinkedDatabase New-AzSqlServerVirtualNetworkRule Set-AzSqlServerVirtualNetworkRule Get-AzSqlServerVirtualNetworkRule Remove-AzSqlServerVirtualNetworkRule Stop-AzSqlDatabaseActivity Get-AzSqlServerDnsAlias Remove-AzSqlServerDnsAlias New-AzSqlServerDnsAlias Set-AzSqlServerDnsAlias New-AzSqlDatabaseRestorePoint Remove-AzSqlDatabaseRestorePoint Stop-AzSqlElasticPoolActivity Add-AzSqlServerTransparentDataEncryptionCertificate Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate Enable-AzSqlServerAdvancedThreatProtection Disable-AzSqlServerAdvancedThreatProtection Get-AzSqlServerAdvancedThreatProtectionPolicy Update-AzSqlDatabaseVulnerabilityAssessmentSettings Get-AzSqlDatabaseVulnerabilityAssessmentSettings Clear-AzSqlDatabaseVulnerabilityAssessmentSettings Set-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Convert-AzSqlDatabaseVulnerabilityAssessmentScan Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord Start-AzSqlDatabaseVulnerabilityAssessmentScan Get-AzSqlInstance New-AzSqlInstance Remove-AzSqlInstance Set-AzSqlInstance Get-AzSqlInstanceDatabase New-AzSqlInstanceDatabase Remove-AzSqlInstanceDatabase Restore-AzSqlInstanceDatabase Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings Set-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Convert-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Get-AzSqlInstanceDatabaseVulnerabilityAssessmentScanRecord Start-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Enable-AzSqlInstanceAdvancedDataSecurity Disable-AzSqlInstanceAdvancedDataSecurity Get-AzSqlInstanceAdvancedDataSecurityPolicy Get-AzSqlInstanceDatabaseGeoBackup Get-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy Get-AzSqlDeletedInstanceDatabaseBackup Update-AzSqlInstanceVulnerabilityAssessmentSettings Get-AzSqlInstanceVulnerabilityAssessmentSettings Clear-AzSqlInstanceVulnerabilityAssessmentSettings Update-AzSqlServerVulnerabilityAssessmentSettings Get-AzSqlServerVulnerabilityAssessmentSettings Clear-AzSqlServerVulnerabilityAssessmentSettings Get-AzSqlDatabaseSensitivityClassification Get-AzSqlInstanceDatabaseSensitivityClassification Set-AzSqlDatabaseSensitivityClassification Set-AzSqlInstanceDatabaseSensitivityClassification Remove-AzSqlDatabaseSensitivityClassification Remove-AzSqlInstanceDatabaseSensitivityClassification Get-AzSqlDatabaseSensitivityRecommendation Get-AzSqlInstanceDatabaseSensitivityRecommendation

PSEditions

Core Desktop

Dependencies

Release Notes

* Support Database Data Classification.

FileList

Version History

Version Downloads Last updated
7.2.0 1,001,145 10/6/2026
7.1.0 3,953,248 8/31/2026
7.0.0 14,500,388 6/2/2026
6.6.0-preview 83 5/13/2026
6.5.0 52,544 5/13/2026
6.4.2 5,492,902 5/5/2026
6.4.1 12,174,271 3/3/2026
6.4.0 9,661,537 1/13/2026
6.3.0 14,225,109 11/4/2025
6.2.0 4,065,223 10/14/2025
6.1.0 8,299,263 9/2/2025
6.0.6-preview 65 8/12/2025
6.0.5 5,266,097 8/5/2025
6.0.4 13,239,674 5/19/2025
6.0.3 4,158,242 5/6/2025
6.0.2 8,556,640 3/4/2025
6.0.1 6,959,691 1/14/2025
6.0.0 5,634,665 11/19/2024
5.3.0 13,591,285 9/3/2024
5.2.0 2,121,763 8/6/2024
5.1.0 3,460,715 7/9/2024
5.0.0 4,858,107 5/21/2024
4.14.1 2,160,621 4/30/2024
4.14.0 6,122,594 2/6/2024
4.13.0 1,592,094 1/9/2024
4.12.0 1,706,058 12/5/2023
4.11.0 1,289,155 11/14/2023
4.10.0 9,303,598 9/5/2023
4.9.0 1,406,890 8/1/2023
4.8.0 1,206,156 7/4/2023
4.7.0 1,594,594 5/23/2023
4.6.0 2,861,951 4/25/2023
4.5.0 876,002 4/4/2023
4.4.0 1,185,606 3/9/2023
4.3.0 2,480,627 2/7/2023
4.2.0 1,375,314 1/10/2023
4.1.0 2,506,396 11/1/2022
4.0.0 1,582,631 10/17/2022
3.11.0 3,094,396 8/2/2022
3.10.0 741,666 7/5/2022
3.9.0 4,078,566 5/24/2022
3.8.0 4,870,292 4/5/2022
3.7.1 1,274,050 2/7/2022
3.7.0 731,388 1/4/2022
3.6.0 576,583 12/7/2021
3.5.1 3,099,904 10/12/2021
3.5.0 811,662 9/7/2021
3.4.1 720,235 7/15/2021
3.4.0 645,533 7/6/2021
3.3.0 13,334 6/23/2021
3.2.0 412,554 6/15/2021
3.1.0 430,205 5/25/2021
3.0.0-preview 731 3/27/2021
2.17.1 4,257,524 4/13/2021
2.17.0 689,266 3/23/2021
2.16.0 1,458,952 2/9/2021
2.15.0 1,664,242 1/19/2021
2.14.0 1,483,254 12/29/2020
2.13.0 1,402,724 12/8/2020
2.12.0 1,723,391 11/17/2020
2.11.1 1,723,381 10/27/2020
2.11.0 4,902,726 9/27/2020
2.10.1 1,617 9/24/2020
2.10.0 268,512 9/22/2020
2.9.1 2,451,730 8/4/2020
2.9.0 375,808 7/14/2020
2.8.0 534,340 6/23/2020
2.7.0 410,490 6/2/2020
2.6.1 344,758 5/19/2020
2.6.0 2,157,247 4/21/2020
2.5.0 305,939 3/16/2020
2.4.0 374,495 3/10/2020
2.3.0 414,901 2/18/2020
2.2.0 668,309 2/4/2020
2.1.2 387,539 1/7/2020
2.1.1 329,953 12/17/2019
2.1.0 619,367 11/26/2019
2.0.0 471,049 11/4/2019
1.15.0 1,186,531 10/15/2019
1.14.2 185,955 9/24/2019
1.14.1 324,156 8/27/2019
1.14.0 1,435 8/19/2019
1.13.1 438,167 7/30/2019
1.13.0 290,925 7/2/2019
1.12.0 179,415 6/18/2019
1.11.0 79,192 6/4/2019
1.10.0 72,678 5/6/2019
1.9.0 484,742 4/23/2019
1.8.0 (current version) 56,255 4/9/2019
1.7.0 84,316 3/26/2019
1.5.0 56,066 3/12/2019
1.4.0 3,428 2/28/2019
1.3.0 43,557 2/26/2019
1.2.0 33,019 2/12/2019
1.1.1-preview 4,502 1/30/2019
1.1.0 29,241 1/29/2019
1.0.1 73,256 1/15/2019
1.0.0 62,706 12/18/2018
0.7.0 12,543 12/4/2018
0.6.2 1,250 12/3/2018
0.6.1 8,728 11/21/2018
0.5.1 8,924 11/8/2018
0.5.0 1,737 11/6/2018
0.4.0 11,379 10/23/2018
0.3.0 11,138 10/9/2018
0.2.3 4,754 9/27/2018
0.2.2 893 9/24/2018
0.1.0 784 8/28/2018
Show less