Az.Sql
1.1.1-preview
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
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
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-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-AzSqlInstanceTransparentDataEncryptionCertificate 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-AzSqlDatabaseBackupShortTermRetentionPolicy Set-AzSqlDatabaseBackupShortTermRetentionPolicy Get-AzSqlDatabaseInstanceFailoverGroup New-AzSqlDatabaseInstanceFailoverGroup Remove-AzSqlDatabaseInstanceFailoverGroup Set-AzSqlDatabaseInstanceFailoverGroup Switch-AzSqlDatabaseInstanceFailoverGroup 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 Add-AzSqlInstanceKeyVaultKey Get-AzSqlInstanceKeyVaultKey Remove-AzSqlInstanceKeyVaultKey Get-AzSqlInstanceTransparentDataEncryptionProtector Set-AzSqlInstanceTransparentDataEncryptionProtector Get-AzSqlInstance New-AzSqlInstance Remove-AzSqlInstance Set-AzSqlInstance Get-AzSqlInstanceDatabase New-AzSqlInstanceDatabase Remove-AzSqlInstanceDatabase Restore-AzSqlInstanceDatabase Enable-AzSqlInstanceAdvancedDataSecurity Disable-AzSqlInstanceAdvancedDataSecurity Get-AzSqlInstanceAdvancedDataSecurityPolicy Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSettings Set-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Convert-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Get-AzSqlInstanceDatabaseVulnerabilityAssessmentScanRecord Start-AzSqlInstanceDatabaseVulnerabilityAssessmentScan
PSEditions
Dependencies
-
- Az.Accounts (>= 1.2.0)
Release Notes
* Update preview with changes from stable
FileList
- Az.Sql.nuspec
- Az.Sql.psd1
- Az.Sql.psm1
- Microsoft.Azure.Commands.Sql.dll-Help.xml
- Microsoft.Azure.Management.Sql.dll
- 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
- Sql.format.ps1xml
- Sql.types.ps1xml
Version History
Version | Downloads | Last updated |
---|---|---|
6.2.0 | 735,308 | 10/14/2025 |
6.1.0 | 8,183,814 | 9/2/2025 |
6.0.6-preview | 51 | 8/12/2025 |
6.0.5 | 5,184,429 | 8/5/2025 |
6.0.4 | 12,999,755 | 5/19/2025 |
6.0.3 | 2,790,556 | 5/6/2025 |
6.0.2 | 8,276,108 | 3/4/2025 |
6.0.1 | 6,784,923 | 1/14/2025 |
6.0.0 | 5,489,941 | 11/19/2024 |
5.3.0 | 10,496,272 | 9/3/2024 |
5.2.0 | 2,094,755 | 8/6/2024 |
5.1.0 | 2,497,853 | 7/9/2024 |
5.0.0 | 4,766,463 | 5/21/2024 |
4.14.1 | 1,868,794 | 4/30/2024 |
4.14.0 | 5,826,578 | 2/6/2024 |
4.13.0 | 1,568,607 | 1/9/2024 |
4.12.0 | 1,673,644 | 12/5/2023 |
4.11.0 | 1,242,085 | 11/14/2023 |
4.10.0 | 7,196,290 | 9/5/2023 |
4.9.0 | 1,404,526 | 8/1/2023 |
4.8.0 | 1,203,286 | 7/4/2023 |
4.7.0 | 1,587,277 | 5/23/2023 |
4.6.0 | 2,629,567 | 4/25/2023 |
4.5.0 | 866,352 | 4/4/2023 |
4.4.0 | 1,176,734 | 3/9/2023 |
4.3.0 | 2,364,613 | 2/7/2023 |
4.2.0 | 1,331,822 | 1/10/2023 |
4.1.0 | 2,487,977 | 11/1/2022 |
4.0.0 | 1,414,799 | 10/17/2022 |
3.11.0 | 2,983,075 | 8/2/2022 |
3.10.0 | 731,084 | 7/5/2022 |
3.9.0 | 4,038,143 | 5/24/2022 |
3.8.0 | 4,744,944 | 4/5/2022 |
3.7.1 | 1,263,763 | 2/7/2022 |
3.7.0 | 722,232 | 1/4/2022 |
3.6.0 | 532,525 | 12/7/2021 |
3.5.1 | 2,913,132 | 10/12/2021 |
3.5.0 | 805,902 | 9/7/2021 |
3.4.1 | 706,934 | 7/15/2021 |
3.4.0 | 628,760 | 7/6/2021 |
3.3.0 | 13,323 | 6/23/2021 |
3.2.0 | 409,401 | 6/15/2021 |
3.1.0 | 422,417 | 5/25/2021 |
3.0.0-preview | 727 | 3/27/2021 |
2.17.1 | 3,911,857 | 4/13/2021 |
2.17.0 | 687,273 | 3/23/2021 |
2.16.0 | 1,457,127 | 2/9/2021 |
2.15.0 | 1,663,439 | 1/19/2021 |
2.14.0 | 1,482,464 | 12/29/2020 |
2.13.0 | 1,402,668 | 12/8/2020 |
2.12.0 | 1,682,917 | 11/17/2020 |
2.11.1 | 1,722,350 | 10/27/2020 |
2.11.0 | 4,183,589 | 9/27/2020 |
2.10.1 | 1,611 | 9/24/2020 |
2.10.0 | 266,881 | 9/22/2020 |
2.9.1 | 2,445,802 | 8/4/2020 |
2.9.0 | 373,814 | 7/14/2020 |
2.8.0 | 534,293 | 6/23/2020 |
2.7.0 | 407,297 | 6/2/2020 |
2.6.1 | 344,281 | 5/19/2020 |
2.6.0 | 2,095,742 | 4/21/2020 |
2.5.0 | 305,885 | 3/16/2020 |
2.4.0 | 374,242 | 3/10/2020 |
2.3.0 | 411,892 | 2/18/2020 |
2.2.0 | 664,900 | 2/4/2020 |
2.1.2 | 387,526 | 1/7/2020 |
2.1.1 | 329,944 | 12/17/2019 |
2.1.0 | 581,200 | 11/26/2019 |
2.0.0 | 468,711 | 11/4/2019 |
1.15.0 | 1,125,488 | 10/15/2019 |
1.14.2 | 185,905 | 9/24/2019 |
1.14.1 | 322,054 | 8/27/2019 |
1.14.0 | 1,430 | 8/19/2019 |
1.13.1 | 416,569 | 7/30/2019 |
1.13.0 | 290,845 | 7/2/2019 |
1.12.0 | 178,077 | 6/18/2019 |
1.11.0 | 79,158 | 6/4/2019 |
1.10.0 | 72,633 | 5/6/2019 |
1.9.0 | 482,009 | 4/23/2019 |
1.8.0 | 55,369 | 4/9/2019 |
1.7.0 | 83,877 | 3/26/2019 |
1.5.0 | 56,061 | 3/12/2019 |
1.4.0 | 3,422 | 2/28/2019 |
1.3.0 | 43,553 | 2/26/2019 |
1.2.0 | 33,014 | 2/12/2019 |
1.1.1-preview (current version) | 4,315 | 1/30/2019 |
1.1.0 | 29,232 | 1/29/2019 |
1.0.1 | 73,248 | 1/15/2019 |
1.0.0 | 61,568 | 12/18/2018 |
0.7.0 | 12,538 | 12/4/2018 |
0.6.2 | 1,247 | 12/3/2018 |
0.6.1 | 8,725 | 11/21/2018 |
0.5.1 | 8,920 | 11/8/2018 |
0.5.0 | 1,733 | 11/6/2018 |
0.4.0 | 11,375 | 10/23/2018 |
0.3.0 | 11,133 | 10/9/2018 |
0.2.3 | 4,748 | 9/27/2018 |
0.2.2 | 887 | 9/24/2018 |
0.1.0 | 777 | 8/28/2018 |