Az.Sql
4.6.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://learn.microsoft.com/azure/sql-database/
Minimum PowerShell version
5.1
See the version list below for details.
Installation Options
Owners
Copyright
Microsoft Corporation. All rights reserved.
Package Details
Author(s)
- Microsoft Corporation
Tags
Azure ResourceManager ARM Sql Database
Cmdlets
Invoke-AzSqlServerExternalGovernanceStatusRefresh 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-AzSqlDatabaseReplicationLink New-AzSqlDatabaseCopy New-AzSqlDatabaseSecondary Remove-AzSqlDatabaseSecondary Set-AzSqlDatabaseSecondary Get-AzSqlElasticPoolRecommendation Get-AzSqlDatabaseIndexRecommendation Start-AzSqlDatabaseExecuteIndexRecommendation Stop-AzSqlDatabaseExecuteIndexRecommendation Get-AzSqlServerFirewallRule New-AzSqlServerFirewallRule Remove-AzSqlServerFirewallRule Set-AzSqlServerFirewallRule Get-AzSqlServerIpv6FirewallRule New-AzSqlServerIpv6FirewallRule Remove-AzSqlServerIpv6FirewallRule Set-AzSqlServerIpv6FirewallRule Get-AzSqlServerOutboundFirewallRule New-AzSqlServerOutboundFirewallRule Remove-AzSqlServerOutboundFirewallRule 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-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 Update-AzSqlDatabaseLongTermRetentionBackup Copy-AzSqlDatabaseLongTermRetentionBackup Remove-AzSqlDatabaseLongTermRetentionBackup Get-AzSqlDeletedDatabaseBackup Get-AzSqlDatabaseGeoBackup Restore-AzSqlDatabase Get-AzSqlDatabaseRestorePoint 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 Update-AzSqlDatabaseVulnerabilityAssessmentSetting Get-AzSqlDatabaseVulnerabilityAssessmentSetting Clear-AzSqlDatabaseVulnerabilityAssessmentSetting Set-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Convert-AzSqlDatabaseVulnerabilityAssessmentScan Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord Start-AzSqlDatabaseVulnerabilityAssessmentScan Get-AzSqlInstance New-AzSqlInstance Remove-AzSqlInstance Get-AzSqlInstanceOperation Stop-AzSqlInstanceOperation Set-AzSqlInstance Get-AzSqlInstanceDatabase New-AzSqlInstanceDatabase Remove-AzSqlInstanceDatabase Restore-AzSqlInstanceDatabase Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting 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-AzSqlInstanceVulnerabilityAssessmentSetting Get-AzSqlInstanceVulnerabilityAssessmentSetting Clear-AzSqlInstanceVulnerabilityAssessmentSetting Update-AzSqlServerVulnerabilityAssessmentSetting Get-AzSqlServerVulnerabilityAssessmentSetting Clear-AzSqlServerVulnerabilityAssessmentSetting Get-AzSqlDatabaseSensitivityClassification Get-AzSqlInstanceDatabaseSensitivityClassification Set-AzSqlDatabaseSensitivityClassification Set-AzSqlInstanceDatabaseSensitivityClassification Remove-AzSqlDatabaseSensitivityClassification Remove-AzSqlInstanceDatabaseSensitivityClassification Get-AzSqlDatabaseSensitivityRecommendation Get-AzSqlInstanceDatabaseSensitivityRecommendation Get-AzSqlVirtualCluster Remove-AzSqlVirtualCluster Enable-AzSqlServerAdvancedDataSecurity Disable-AzSqlServerAdvancedDataSecurity Get-AzSqlServerAdvancedDataSecurityPolicy Get-AzSqlDatabaseInstanceFailoverGroup New-AzSqlDatabaseInstanceFailoverGroup Remove-AzSqlDatabaseInstanceFailoverGroup Set-AzSqlDatabaseInstanceFailoverGroup Switch-AzSqlDatabaseInstanceFailoverGroup Add-AzSqlInstanceKeyVaultKey Get-AzSqlInstanceKeyVaultKey Remove-AzSqlInstanceKeyVaultKey Get-AzSqlInstanceTransparentDataEncryptionProtector Set-AzSqlInstanceTransparentDataEncryptionProtector Get-AzSqlServerAudit Get-AzSqlDatabaseAudit Set-AzSqlServerAudit Set-AzSqlDatabaseAudit Get-AzSqlServerMSSupportAudit Set-AzSqlServerMSSupportAudit Remove-AzSqlServerMSSupportAudit Get-AzSqlInstanceActiveDirectoryAdministrator Remove-AzSqlInstanceActiveDirectoryAdministrator Set-AzSqlInstanceActiveDirectoryAdministrator Remove-AzSqlServerAudit Remove-AzSqlDatabaseAudit Get-AzSqlInstancePool Set-AzSqlInstancePool New-AzSqlInstancePool Remove-AzSqlInstancePool Get-AzSqlInstancePoolUsage Invoke-AzSqlDatabaseFailover Invoke-AzSqlElasticPoolFailover New-AzSqlElasticJobAgent Remove-AzSqlElasticJobAgent Get-AzSqlElasticJobAgent Set-AzSqlElasticJobAgent New-AzSqlElasticJobCredential Get-AzSqlElasticJobCredential Set-AzSqlElasticJobCredential Remove-AzSqlElasticJobCredential New-AzSqlElasticJobTargetGroup Get-AzSqlElasticJobTargetGroup Remove-AzSqlElasticJobTargetGroup Add-AzSqlElasticJobTarget Remove-AzSqlElasticJobTarget New-AzSqlElasticJob Get-AzSqlElasticJob Set-AzSqlElasticJob Remove-AzSqlElasticJob Add-AzSqlElasticJobStep Get-AzSqlElasticJobStep Remove-AzSqlElasticJobStep Set-AzSqlElasticJobStep Start-AzSqlElasticJob Stop-AzSqlElasticJob Get-AzSqlElasticJobExecution Get-AzSqlElasticJobStepExecution Get-AzSqlElasticJobTargetExecution Enable-AzSqlDatabaseSensitivityRecommendation Disable-AzSqlDatabaseSensitivityRecommendation Enable-AzSqlInstanceDatabaseSensitivityRecommendation Disable-AzSqlInstanceDatabaseSensitivityRecommendation Get-AzSqlInstanceDatabaseLongTermRetentionBackup Remove-AzSqlInstanceDatabaseLongTermRetentionBackup Get-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy Set-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy Disable-AzSqlServerActiveDirectoryOnlyAuthentication Invoke-AzSqlInstanceFailover Enable-AzSqlServerActiveDirectoryOnlyAuthentication Get-AzSqlServerActiveDirectoryOnlyAuthentication Start-AzSqlInstanceDatabaseLogReplay Complete-AzSqlInstanceDatabaseLogReplay Stop-AzSqlInstanceDatabaseLogReplay Get-AzSqlInstanceDatabaseLogReplay Disable-AzSqlInstanceActiveDirectoryOnlyAuthentication Enable-AzSqlInstanceActiveDirectoryOnlyAuthentication Get-AzSqlInstanceActiveDirectoryOnlyAuthentication Get-AzSqlServerTrustGroup New-AzSqlServerTrustGroup Remove-AzSqlServerTrustGroup Enable-AzSqlDatabaseLedgerDigestUpload Disable-AzSqlDatabaseLedgerDigestUpload Get-AzSqlDatabaseLedgerDigestUpload New-AzSqlInstanceServerTrustCertificate Get-AzSqlInstanceServerTrustCertificate Remove-AzSqlInstanceServerTrustCertificate New-AzSqlInstanceLink Get-AzSqlInstanceLink Remove-AzSqlInstanceLink Update-AzSqlInstanceLink Get-AzSqlInstanceEndpointCertificate Set-AzSqlInstanceDatabase Get-AzSqlDatabaseAdvancedThreatProtectionSetting Get-AzSqlServerAdvancedThreatProtectionSetting Get-AzSqlInstanceDatabaseAdvancedThreatProtectionSetting Get-AzSqlInstanceAdvancedThreatProtectionSetting Update-AzSqlDatabaseAdvancedThreatProtectionSetting Update-AzSqlServerAdvancedThreatProtectionSetting Update-AzSqlInstanceDatabaseAdvancedThreatProtectionSetting Update-AzSqlInstanceAdvancedThreatProtectionSetting Get-AzSqlInstanceDtc Set-AzSqlInstanceDtc Invoke-AzSqlDatabaseTransparentDataEncryptionProtectorRevalidation Invoke-AzSqlDatabaseTransparentDataEncryptionProtectorRevert Invoke-AzSqlServerTransparentDataEncryptionProtectorRevalidation Invoke-AzSqlInstanceTransparentDataEncryptionProtectorRevalidation Get-AzSqlServerConfigurationOption Set-AzSqlServerConfigurationOption
PSEditions
Dependencies
-
- Az.Accounts (>= 2.12.2)
Release Notes
* Added new cmdlets for managing server configuration options
- 'Set-AzSqlServerConfigurationOption'
- 'Get-AzSqlServerConfigurationOption'
FileList
- Az.Sql.nuspec
- Az.Sql.psd1
- Az.Sql.psm1
- Microsoft.Azure.PowerShell.Cmdlets.Sql.deps.json
- Microsoft.Azure.PowerShell.Cmdlets.Sql.dll
- Microsoft.Azure.PowerShell.Cmdlets.Sql.dll-Help.xml
- Microsoft.Azure.PowerShell.Cmdlets.Sql.LegacySdk.deps.json
- Microsoft.Azure.PowerShell.Cmdlets.Sql.LegacySdk.dll
- Microsoft.Azure.PowerShell.Sql.Sdk.deps.json
- Microsoft.Azure.PowerShell.Sql.Sdk.dll
- Sql.format.ps1xml
- Sql.types.ps1xml
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 7.3.0 | 724,619 | 11/3/2026 |
| 7.2.0 | 2,170,577 | 10/6/2026 |
| 7.1.0 | 3,954,848 | 8/31/2026 |
| 7.0.0 | 14,578,389 | 6/2/2026 |
| 6.6.0-preview | 85 | 5/13/2026 |
| 6.5.0 | 53,127 | 5/13/2026 |
| 6.4.2 | 5,536,031 | 5/5/2026 |
| 6.4.1 | 12,200,210 | 3/3/2026 |
| 6.4.0 | 9,665,780 | 1/13/2026 |
| 6.3.0 | 14,308,110 | 11/4/2025 |
| 6.2.0 | 4,066,440 | 10/14/2025 |
| 6.1.0 | 8,303,007 | 9/2/2025 |
| 6.0.6-preview | 67 | 8/12/2025 |
| 6.0.5 | 5,267,586 | 8/5/2025 |
| 6.0.4 | 13,260,204 | 5/19/2025 |
| 6.0.3 | 4,237,536 | 5/6/2025 |
| 6.0.2 | 8,562,895 | 3/4/2025 |
| 6.0.1 | 6,970,936 | 1/14/2025 |
| 6.0.0 | 5,647,392 | 11/19/2024 |
| 5.3.0 | 13,733,168 | 9/3/2024 |
| 5.2.0 | 2,122,800 | 8/6/2024 |
| 5.1.0 | 3,523,061 | 7/9/2024 |
| 5.0.0 | 4,864,986 | 5/21/2024 |
| 4.14.1 | 2,175,444 | 4/30/2024 |
| 4.14.0 | 6,142,146 | 2/6/2024 |
| 4.13.0 | 1,593,578 | 1/9/2024 |
| 4.12.0 | 1,707,405 | 12/5/2023 |
| 4.11.0 | 1,289,926 | 11/14/2023 |
| 4.10.0 | 9,452,032 | 9/5/2023 |
| 4.9.0 | 1,407,064 | 8/1/2023 |
| 4.8.0 | 1,206,303 | 7/4/2023 |
| 4.7.0 | 1,595,150 | 5/23/2023 |
| 4.6.0 (current version) | 2,876,248 | 4/25/2023 |
| 4.5.0 | 876,443 | 4/4/2023 |
| 4.4.0 | 1,185,994 | 3/9/2023 |
| 4.3.0 | 2,483,810 | 2/7/2023 |
| 4.2.0 | 1,378,220 | 1/10/2023 |
| 4.1.0 | 2,506,893 | 11/1/2022 |
| 4.0.0 | 1,583,276 | 10/17/2022 |
| 3.11.0 | 3,101,348 | 8/2/2022 |
| 3.10.0 | 741,961 | 7/5/2022 |
| 3.9.0 | 4,082,425 | 5/24/2022 |
| 3.8.0 | 4,878,055 | 4/5/2022 |
| 3.7.1 | 1,274,349 | 2/7/2022 |
| 3.7.0 | 731,766 | 1/4/2022 |
| 3.6.0 | 581,577 | 12/7/2021 |
| 3.5.1 | 3,108,631 | 10/12/2021 |
| 3.5.0 | 811,912 | 9/7/2021 |
| 3.4.1 | 721,920 | 7/15/2021 |
| 3.4.0 | 646,700 | 7/6/2021 |
| 3.3.0 | 13,336 | 6/23/2021 |
| 3.2.0 | 412,680 | 6/15/2021 |
| 3.1.0 | 430,904 | 5/25/2021 |
| 3.0.0-preview | 733 | 3/27/2021 |
| 2.17.1 | 4,278,790 | 4/13/2021 |
| 2.17.0 | 689,305 | 3/23/2021 |
| 2.16.0 | 1,459,019 | 2/9/2021 |
| 2.15.0 | 1,664,968 | 1/19/2021 |
| 2.14.0 | 1,483,305 | 12/29/2020 |
| 2.13.0 | 1,402,726 | 12/8/2020 |
| 2.12.0 | 1,728,137 | 11/17/2020 |
| 2.11.1 | 1,723,475 | 10/27/2020 |
| 2.11.0 | 4,941,963 | 9/27/2020 |
| 2.10.1 | 1,619 | 9/24/2020 |
| 2.10.0 | 268,573 | 9/22/2020 |
| 2.9.1 | 2,451,965 | 8/4/2020 |
| 2.9.0 | 375,957 | 7/14/2020 |
| 2.8.0 | 534,344 | 6/23/2020 |
| 2.7.0 | 410,709 | 6/2/2020 |
| 2.6.1 | 344,785 | 5/19/2020 |
| 2.6.0 | 2,161,428 | 4/21/2020 |
| 2.5.0 | 305,945 | 3/16/2020 |
| 2.4.0 | 374,499 | 3/10/2020 |
| 2.3.0 | 415,046 | 2/18/2020 |
| 2.2.0 | 668,546 | 2/4/2020 |
| 2.1.2 | 387,541 | 1/7/2020 |
| 2.1.1 | 329,956 | 12/17/2019 |
| 2.1.0 | 620,161 | 11/26/2019 |
| 2.0.0 | 471,134 | 11/4/2019 |
| 1.15.0 | 1,189,889 | 10/15/2019 |
| 1.14.2 | 185,958 | 9/24/2019 |
| 1.14.1 | 324,224 | 8/27/2019 |
| 1.14.0 | 1,437 | 8/19/2019 |
| 1.13.1 | 439,189 | 7/30/2019 |
| 1.13.0 | 290,933 | 7/2/2019 |
| 1.12.0 | 179,534 | 6/18/2019 |
| 1.11.0 | 79,194 | 6/4/2019 |
| 1.10.0 | 72,681 | 5/6/2019 |
| 1.9.0 | 484,865 | 4/23/2019 |
| 1.8.0 | 56,295 | 4/9/2019 |
| 1.7.0 | 84,324 | 3/26/2019 |
| 1.5.0 | 56,068 | 3/12/2019 |
| 1.4.0 | 3,431 | 2/28/2019 |
| 1.3.0 | 43,559 | 2/26/2019 |
| 1.2.0 | 33,021 | 2/12/2019 |
| 1.1.1-preview | 4,530 | 1/30/2019 |
| 1.1.0 | 29,244 | 1/29/2019 |
| 1.0.1 | 73,260 | 1/15/2019 |
| 1.0.0 | 62,763 | 12/18/2018 |
| 0.7.0 | 12,547 | 12/4/2018 |
| 0.6.2 | 1,252 | 12/3/2018 |
| 0.6.1 | 8,730 | 11/21/2018 |
| 0.5.1 | 8,927 | 11/8/2018 |
| 0.5.0 | 1,739 | 11/6/2018 |
| 0.4.0 | 11,382 | 10/23/2018 |
| 0.3.0 | 11,140 | 10/9/2018 |
| 0.2.3 | 4,756 | 9/27/2018 |
| 0.2.2 | 895 | 9/24/2018 |
| 0.1.0 | 786 | 8/28/2018 |