Az.Sql
1.11.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
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-AzSqlDatabaseIndexRecommendation 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-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-AzSqlDatabaseRestorePoint 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 Update-AzSqlDatabaseVulnerabilityAssessmentSetting Get-AzSqlDatabaseVulnerabilityAssessmentSetting Clear-AzSqlDatabaseVulnerabilityAssessmentSetting 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-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-AzSqlServerAdvancedThreatProtectionSettings Clear-AzSqlServerAdvancedThreatProtectionSettings Update-AzSqlServerAdvancedThreatProtectionSettings Get-AzSqlDatabaseAdvancedThreatProtectionSettings Update-AzSqlDatabaseAdvancedThreatProtectionSettings Clear-AzSqlDatabaseAdvancedThreatProtectionSettings
PSEditions
Dependencies
-
- Az.Accounts (>= 1.5.2)
Release Notes
* Add DnsZonePartner Parameter for New-AzureSqlInstance cmdlet to support AutoDr for Managed Instance.
* Deprecating Get-AzSqlDatabaseSecureConnectionPolicy cmdlet
* Rename Threat Detection cmdlets to Advanced Threat Protection
* New-AzSqlInstance -StorageSizeInGB and -LicenseType parameters are now optional.
FileList
- Az.Sql.nuspec
- Az.Sql.psd1
- Az.Sql.psm1
- 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 |
---|---|---|
3.8.0 | 16 | 4/1/2022 |
3.7.1 | 342 | 2/4/2022 |
3.7.0 | 137 | 12/31/2021 |
3.6.0 | 103 | 12/3/2021 |
3.5.1 | 171 | 10/8/2021 |
3.5.0 | 106 | 9/3/2021 |
3.4.1 | 141 | 7/15/2021 |
3.4.0 | 135 | 7/2/2021 |
3.3.0 | 1 | 6/23/2021 |
3.2.0 | 103 | 6/11/2021 |
3.1.0 | 95 | 5/21/2021 |
3.0.0-preview | 2 | 3/26/2021 |
2.17.1 | 137 | 4/9/2021 |
2.17.0 | 89 | 3/19/2021 |
2.16.0 | 156 | 2/5/2021 |
2.15.0 | 67 | 1/15/2021 |
2.14.0 | 76 | 12/25/2020 |
2.13.0 | 76 | 12/4/2020 |
2.12.0 | 84 | 11/13/2020 |
2.11.1 | 76 | 10/23/2020 |
2.11.0 | 54 | 9/27/2020 |
2.10.1 | 1 | 9/24/2020 |
2.10.0 | 152 | 9/16/2020 |
2.9.1 | 258 | 7/31/2020 |
2.9.0 | 103 | 7/10/2020 |
2.8.0 | 83 | 6/19/2020 |
2.7.0 | 63 | 5/29/2020 |
2.6.1 | 54 | 5/15/2020 |
2.6.0 | 199 | 4/17/2020 |
2.5.0 | 64 | 3/16/2020 |
2.4.0 | 38 | 3/6/2020 |
2.3.0 | 36 | 2/14/2020 |
2.2.0 | 823 | 1/31/2020 |
2.1.2 | 38 | 1/3/2020 |
2.1.1 | 19 | 12/13/2019 |
2.1.0 | 24 | 11/22/2019 |
2.0.0 | 51 | 10/30/2019 |
1.15.0 | 45 | 10/11/2019 |
1.14.2 | 55 | 9/20/2019 |
1.14.1 | 45 | 8/23/2019 |
1.14.0 | 5 | 8/19/2019 |
1.13.1 | 78 | 7/26/2019 |
1.13.0 | 1,140 | 6/28/2019 |
1.12.0 | 36 | 6/14/2019 |
1.11.0 (current version) | 27 | 5/31/2019 |
1.10.0 | 17 | 5/6/2019 |
1.9.0 | 50 | 4/19/2019 |
1.8.0 | 20 | 4/5/2019 |
1.7.0 | 27 | 3/22/2019 |
1.5.0 | 14 | 3/8/2019 |
1.4.0 | 5 | 2/28/2019 |
1.3.0 | 16 | 2/22/2019 |
1.2.0 | 22 | 2/8/2019 |
1.1.1-preview | 2 | 1/30/2019 |
1.1.0 | 21 | 1/25/2019 |
1.0.1 | 527 | 1/11/2019 |
1.0.0 | 55 | 12/14/2018 |
0.7.0 | 32 | 11/30/2018 |
0.6.2 | 2 | 12/3/2018 |
0.6.1 | 14 | 11/21/2018 |
0.6.0 | 23 | 11/16/2018 |
0.5.1 | 9 | 11/8/2018 |
0.5.0 | 14 | 11/2/2018 |
0.4.0 | 18 | 10/19/2018 |
0.3.0 | 21 | 10/5/2018 |
0.2.3 | 24 | 9/27/2018 |
0.2.2 | 25 | 9/24/2018 |
0.2.0 | 37 | 9/17/2018 |
0.1.0 | 54 | 8/24/2018 |