Az.Sql
5.0.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
Installation Options
Owners
Copyright
Microsoft Corporation. All rights reserved.
Package Details
Author(s)
- Microsoft Corporation
Tags
Azure ResourceManager ARM Sql Database
Cmdlets
Add-AzSqlDatabaseToFailoverGroup Add-AzSqlElasticJobStep Add-AzSqlElasticJobTarget Add-AzSqlInstanceKeyVaultKey Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate Add-AzSqlServerKeyVaultKey Add-AzSqlServerTransparentDataEncryptionCertificate Clear-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlDatabaseVulnerabilityAssessmentSetting Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Clear-AzSqlInstanceVulnerabilityAssessmentSetting Clear-AzSqlServerVulnerabilityAssessmentSetting Complete-AzSqlInstanceDatabaseCopy Complete-AzSqlInstanceDatabaseLogReplay Complete-AzSqlInstanceDatabaseMove Convert-AzSqlDatabaseVulnerabilityAssessmentScan Convert-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Copy-AzSqlDatabaseLongTermRetentionBackup Copy-AzSqlInstanceDatabase Disable-AzSqlDatabaseLedgerDigestUpload Disable-AzSqlDatabaseSensitivityRecommendation Disable-AzSqlInstanceActiveDirectoryOnlyAuthentication Disable-AzSqlInstanceAdvancedDataSecurity Disable-AzSqlInstanceDatabaseLedgerDigestUpload Disable-AzSqlInstanceDatabaseSensitivityRecommendation Disable-AzSqlServerActiveDirectoryOnlyAuthentication Disable-AzSqlServerAdvancedDataSecurity Enable-AzSqlDatabaseLedgerDigestUpload Enable-AzSqlDatabaseSensitivityRecommendation Enable-AzSqlInstanceActiveDirectoryOnlyAuthentication Enable-AzSqlInstanceAdvancedDataSecurity Enable-AzSqlInstanceDatabaseLedgerDigestUpload Enable-AzSqlInstanceDatabaseSensitivityRecommendation Enable-AzSqlServerActiveDirectoryOnlyAuthentication Enable-AzSqlServerAdvancedDataSecurity Get-AzSqlCapability Get-AzSqlDatabase Get-AzSqlDatabaseActivity Get-AzSqlDatabaseAdvancedThreatProtectionSetting Get-AzSqlDatabaseAdvisor Get-AzSqlDatabaseAudit Get-AzSqlDatabaseBackupLongTermRetentionPolicy Get-AzSqlDatabaseBackupShortTermRetentionPolicy Get-AzSqlDatabaseDataMaskingPolicy Get-AzSqlDatabaseDataMaskingRule Get-AzSqlDatabaseExpanded Get-AzSqlDatabaseFailoverGroup Get-AzSqlDatabaseGeoBackup Get-AzSqlDatabaseGeoBackupPolicy Get-AzSqlDatabaseImportExportStatus Get-AzSqlDatabaseIndexRecommendation Get-AzSqlDatabaseInstanceFailoverGroup Get-AzSqlDatabaseLedgerDigestUpload Get-AzSqlDatabaseLongTermRetentionBackup Get-AzSqlDatabaseRecommendedAction Get-AzSqlDatabaseReplicationLink Get-AzSqlDatabaseRestorePoint Get-AzSqlDatabaseSensitivityClassification Get-AzSqlDatabaseSensitivityRecommendation Get-AzSqlDatabaseTransparentDataEncryption Get-AzSqlDatabaseUpgradeHint Get-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord Get-AzSqlDatabaseVulnerabilityAssessmentSetting Get-AzSqlDeletedDatabaseBackup Get-AzSqlDeletedInstanceDatabaseBackup Get-AzSqlElasticJob Get-AzSqlElasticJobAgent Get-AzSqlElasticJobCredential Get-AzSqlElasticJobExecution Get-AzSqlElasticJobPrivateEndpoint Get-AzSqlElasticJobStep Get-AzSqlElasticJobStepExecution Get-AzSqlElasticJobTargetExecution Get-AzSqlElasticJobTargetGroup Get-AzSqlElasticPool Get-AzSqlElasticPoolActivity Get-AzSqlElasticPoolAdvisor Get-AzSqlElasticPoolDatabase Get-AzSqlElasticPoolRecommendation Get-AzSqlElasticPoolRecommendedAction Get-AzSqlInstance Get-AzSqlInstanceActiveDirectoryAdministrator Get-AzSqlInstanceActiveDirectoryOnlyAuthentication Get-AzSqlInstanceAdvancedDataSecurityPolicy Get-AzSqlInstanceAdvancedThreatProtectionSetting Get-AzSqlInstanceDatabase Get-AzSqlInstanceDatabaseAdvancedThreatProtectionSetting Get-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy Get-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy Get-AzSqlInstanceDatabaseCopyOperation Get-AzSqlInstanceDatabaseGeoBackup Get-AzSqlInstanceDatabaseLedgerDigestUpload Get-AzSqlInstanceDatabaseLogReplay Get-AzSqlInstanceDatabaseLongTermRetentionBackup Get-AzSqlInstanceDatabaseMoveOperation Get-AzSqlInstanceDatabaseSensitivityClassification Get-AzSqlInstanceDatabaseSensitivityRecommendation Get-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Get-AzSqlInstanceDatabaseVulnerabilityAssessmentScanRecord Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Get-AzSqlInstanceDtc Get-AzSqlInstanceEndpointCertificate Get-AzSqlInstanceKeyVaultKey Get-AzSqlInstanceLink Get-AzSqlInstanceOperation Get-AzSqlInstancePool Get-AzSqlInstancePoolUsage Get-AzSqlInstanceServerTrustCertificate Get-AzSqlInstanceStartStopSchedule Get-AzSqlInstanceTransparentDataEncryptionProtector Get-AzSqlInstanceVulnerabilityAssessmentSetting Get-AzSqlServer Get-AzSqlServerActiveDirectoryAdministrator Get-AzSqlServerActiveDirectoryOnlyAuthentication Get-AzSqlServerAdvancedDataSecurityPolicy Get-AzSqlServerAdvancedThreatProtectionSetting Get-AzSqlServerAdvisor Get-AzSqlServerAudit Get-AzSqlServerCommunicationLink Get-AzSqlServerConfigurationOption Get-AzSqlServerDisasterRecoveryConfiguration Get-AzSqlServerDisasterRecoveryConfigurationActivity Get-AzSqlServerDnsAlias Get-AzSqlServerFirewallRule Get-AzSqlServerIpv6FirewallRule Get-AzSqlServerKeyVaultKey Get-AzSqlServerMSSupportAudit Get-AzSqlServerOutboundFirewallRule Get-AzSqlServerRecommendedAction Get-AzSqlServerServiceObjective Get-AzSqlServerTransparentDataEncryptionProtector Get-AzSqlServerTrustGroup Get-AzSqlServerUpgradeHint Get-AzSqlServerVirtualNetworkRule Get-AzSqlServerVulnerabilityAssessmentSetting Get-AzSqlSyncAgent Get-AzSqlSyncAgentLinkedDatabase Get-AzSqlSyncGroup Get-AzSqlSyncGroupLog Get-AzSqlSyncMember Get-AzSqlSyncSchema Get-AzSqlVirtualCluster Invoke-AzSqlDatabaseFailover Invoke-AzSqlDatabaseTransparentDataEncryptionProtectorRevalidation Invoke-AzSqlDatabaseTransparentDataEncryptionProtectorRevert Invoke-AzSqlElasticPoolFailover Invoke-AzSqlInstanceFailover Invoke-AzSqlInstanceExternalGovernanceStatusRefresh Invoke-AzSqlInstanceTransparentDataEncryptionProtectorRevalidation Invoke-AzSqlServerExternalGovernanceStatusRefresh Invoke-AzSqlServerTransparentDataEncryptionProtectorRevalidation Move-AzSqlInstanceDatabase New-AzSqlDatabase New-AzSqlDatabaseCopy New-AzSqlDatabaseDataMaskingRule New-AzSqlDatabaseExport New-AzSqlDatabaseFailoverGroup New-AzSqlDatabaseImport New-AzSqlDatabaseInstanceFailoverGroup New-AzSqlDatabaseRestorePoint New-AzSqlDatabaseSecondary New-AzSqlElasticJob New-AzSqlElasticJobAgent New-AzSqlElasticJobCredential New-AzSqlElasticJobPrivateEndpoint New-AzSqlElasticJobTargetGroup New-AzSqlElasticPool New-AzSqlInstance New-AzSqlInstanceDatabase New-AzSqlInstanceLink New-AzSqlInstancePool New-AzSqlInstanceScheduleItem New-AzSqlInstanceServerTrustCertificate New-AzSqlInstanceStartStopSchedule New-AzSqlServer New-AzSqlServerCommunicationLink New-AzSqlServerDisasterRecoveryConfiguration New-AzSqlServerDnsAlias New-AzSqlServerFirewallRule New-AzSqlServerIpv6FirewallRule New-AzSqlServerOutboundFirewallRule New-AzSqlServerTrustGroup New-AzSqlServerVirtualNetworkRule New-AzSqlSyncAgent New-AzSqlSyncAgentKey New-AzSqlSyncGroup New-AzSqlSyncMember Remove-AzSqlDatabase Remove-AzSqlDatabaseAudit Remove-AzSqlDatabaseDataMaskingRule Remove-AzSqlDatabaseFailoverGroup Remove-AzSqlDatabaseFromFailoverGroup Remove-AzSqlDatabaseInstanceFailoverGroup Remove-AzSqlDatabaseLongTermRetentionBackup Remove-AzSqlDatabaseRestorePoint Remove-AzSqlDatabaseSecondary Remove-AzSqlDatabaseSensitivityClassification Remove-AzSqlElasticJob Remove-AzSqlElasticJobAgent Remove-AzSqlElasticJobCredential Remove-AzSqlElasticJobPrivateEndpoint Remove-AzSqlElasticJobStep Remove-AzSqlElasticJobTarget Remove-AzSqlElasticJobTargetGroup Remove-AzSqlElasticPool Remove-AzSqlInstance Remove-AzSqlInstanceActiveDirectoryAdministrator Remove-AzSqlInstanceDatabase Remove-AzSqlInstanceDatabaseLongTermRetentionBackup Remove-AzSqlInstanceDatabaseSensitivityClassification Remove-AzSqlInstanceKeyVaultKey Remove-AzSqlInstanceLink Remove-AzSqlInstancePool Remove-AzSqlInstanceServerTrustCertificate Remove-AzSqlInstanceStartStopSchedule Remove-AzSqlServer Remove-AzSqlServerActiveDirectoryAdministrator Remove-AzSqlServerAudit Remove-AzSqlServerCommunicationLink Remove-AzSqlServerDisasterRecoveryConfiguration Remove-AzSqlServerDnsAlias Remove-AzSqlServerFirewallRule Remove-AzSqlServerIpv6FirewallRule Remove-AzSqlServerKeyVaultKey Remove-AzSqlServerMSSupportAudit Remove-AzSqlServerOutboundFirewallRule Remove-AzSqlServerTrustGroup Remove-AzSqlServerVirtualNetworkRule Remove-AzSqlSyncAgent Remove-AzSqlSyncGroup Remove-AzSqlSyncMember Remove-AzSqlVirtualCluster Restore-AzSqlDatabase Restore-AzSqlInstanceDatabase Resume-AzSqlDatabase Set-AzSqlDatabase Set-AzSqlDatabaseAdvisorAutoExecuteStatus Set-AzSqlDatabaseAudit Set-AzSqlDatabaseBackupLongTermRetentionPolicy Set-AzSqlDatabaseBackupShortTermRetentionPolicy Set-AzSqlDatabaseDataMaskingPolicy Set-AzSqlDatabaseDataMaskingRule Set-AzSqlDatabaseFailoverGroup Set-AzSqlDatabaseGeoBackupPolicy Set-AzSqlDatabaseInstanceFailoverGroup Set-AzSqlDatabaseRecommendedActionState Set-AzSqlDatabaseSecondary Set-AzSqlDatabaseSensitivityClassification Set-AzSqlDatabaseTransparentDataEncryption Set-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline Set-AzSqlElasticJob Set-AzSqlElasticJobAgent Set-AzSqlElasticJobCredential Set-AzSqlElasticJobStep Set-AzSqlElasticPool Set-AzSqlElasticPoolAdvisorAutoExecuteStatus Set-AzSqlElasticPoolRecommendedActionState Set-AzSqlInstance Set-AzSqlInstanceActiveDirectoryAdministrator Set-AzSqlInstanceDatabase Set-AzSqlInstanceDatabaseBackupLongTermRetentionPolicy Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy Set-AzSqlInstanceDatabaseSensitivityClassification Set-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline Set-AzSqlInstanceDtc Set-AzSqlInstancePool Set-AzSqlInstanceTransparentDataEncryptionProtector Set-AzSqlServer Set-AzSqlServerActiveDirectoryAdministrator Set-AzSqlServerAdvisorAutoExecuteStatus Set-AzSqlServerAudit Set-AzSqlServerConfigurationOption Set-AzSqlServerDisasterRecoveryConfiguration Set-AzSqlServerDnsAlias Set-AzSqlServerFirewallRule Set-AzSqlServerIpv6FirewallRule Set-AzSqlServerMSSupportAudit Set-AzSqlServerRecommendedActionState Set-AzSqlServerTransparentDataEncryptionProtector Set-AzSqlServerVirtualNetworkRule Start-AzSqlDatabaseExecuteIndexRecommendation Start-AzSqlDatabaseVulnerabilityAssessmentScan Start-AzSqlElasticJob Start-AzSqlInstance Start-AzSqlInstanceDatabaseLogReplay Start-AzSqlInstanceDatabaseVulnerabilityAssessmentScan Start-AzSqlSyncGroupSync Stop-AzSqlDatabaseActivity Stop-AzSqlDatabaseExecuteIndexRecommendation Stop-AzSqlElasticJob Stop-AzSqlElasticPoolActivity Stop-AzSqlInstance Stop-AzSqlInstanceDatabaseCopy Stop-AzSqlInstanceDatabaseLogReplay Stop-AzSqlInstanceDatabaseMove Stop-AzSqlInstanceOperation Stop-AzSqlSyncGroupSync Suspend-AzSqlDatabase Switch-AzSqlDatabaseFailoverGroup Switch-AzSqlDatabaseInstanceFailoverGroup Update-AzSqlDatabaseAdvancedThreatProtectionSetting Update-AzSqlDatabaseLongTermRetentionBackup Update-AzSqlDatabaseVulnerabilityAssessmentSetting Update-AzSqlInstanceAdvancedThreatProtectionSetting Update-AzSqlInstanceDatabaseAdvancedThreatProtectionSetting Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting Update-AzSqlInstanceLink Update-AzSqlInstanceVulnerabilityAssessmentSetting Update-AzSqlServerAdvancedThreatProtectionSetting Update-AzSqlServerVulnerabilityAssessmentSetting Update-AzSqlSyncGroup Update-AzSqlSyncMember Update-AzSqlSyncSchema
PSEditions
Dependencies
-
- Az.Accounts (>= 3.0.0)
Release Notes
* Added multi-secondary support for 'Get-AzSqlDatabaseFailoverGroup', 'Remove-AzSqlDatabaseFromFailoverGroup' and 'Add-AzSqlDatabaseFromFailoverGroup'
* Changed default FailoverPolicy value for 'New-AzSqlDatabaseFailoverGroup', 'Set-AzSqlDatabaseFailoverGroup' from 'Automatic' to 'Manual'
* Added 'ManualCutover' and 'PerformCutover' parameters to 'Set-AzSqlInstance' for Azure Sql Sterling database to Azure Sql Hyperscale database
* Added 'OperationPhaseDetails' parameter to 'Get-AzSqlDatabaseActivity' and updated 'DatabaseOperations' Api to version '2022-11-01-preview' for .Net Sdk
FileList
- Az.Sql.nuspec
- Az.Sql.psd1
- Microsoft.Azure.PowerShell.Cmdlets.Sql.LegacySdk.dll
- Az.Sql.psm1
- Microsoft.Azure.PowerShell.Sql.Management.Sdk.dll
- Microsoft.Azure.PowerShell.Cmdlets.Sql.dll
- Sql.format.ps1xml
- Microsoft.Azure.PowerShell.Cmdlets.Sql.dll-Help.xml
- Sql.types.ps1xml
Version History
Version | Downloads | Last updated |
---|---|---|
5.0.0 (current version) | 1,579,082 | 5/21/2024 |
4.14.1 | 1,379,378 | 4/30/2024 |
4.14.0 | 5,133,669 | 2/6/2024 |
4.13.0 | 1,532,201 | 1/9/2024 |
4.12.0 | 1,646,644 | 12/5/2023 |
4.11.0 | 1,173,736 | 11/14/2023 |
4.10.0 | 4,023,449 | 9/5/2023 |
4.9.0 | 1,395,548 | 8/1/2023 |
4.8.0 | 1,196,256 | 7/4/2023 |
4.7.0 | 1,565,810 | 5/23/2023 |
4.6.0 | 2,006,391 | 4/25/2023 |
4.5.0 | 844,811 | 4/4/2023 |
4.4.0 | 1,156,757 | 3/9/2023 |
4.3.0 | 1,233,653 | 2/7/2023 |
4.2.0 | 1,252,038 | 1/10/2023 |
4.1.0 | 2,414,635 | 11/1/2022 |
4.0.0 | 856,053 | 10/17/2022 |
3.11.0 | 2,740,336 | 8/2/2022 |
3.10.0 | 709,503 | 7/5/2022 |
3.9.0 | 3,915,099 | 5/24/2022 |
3.8.0 | 3,677,413 | 4/5/2022 |
3.7.1 | 1,199,909 | 2/7/2022 |
3.7.0 | 710,174 | 1/4/2022 |
3.6.0 | 521,867 | 12/7/2021 |
3.5.1 | 2,539,350 | 10/12/2021 |
3.5.0 | 796,136 | 9/7/2021 |
3.4.1 | 693,694 | 7/15/2021 |
3.4.0 | 600,331 | 7/6/2021 |
3.3.0 | 13,308 | 6/23/2021 |
3.2.0 | 400,512 | 6/15/2021 |
3.1.0 | 413,517 | 5/25/2021 |
3.0.0-preview | 721 | 3/27/2021 |
2.17.1 | 3,259,625 | 4/13/2021 |
2.17.0 | 675,502 | 3/23/2021 |
2.16.0 | 1,444,094 | 2/9/2021 |
2.15.0 | 1,661,676 | 1/19/2021 |
2.14.0 | 1,472,447 | 12/29/2020 |
2.13.0 | 1,396,806 | 12/8/2020 |
2.12.0 | 1,634,629 | 11/17/2020 |
2.11.1 | 1,721,247 | 10/27/2020 |
2.11.0 | 3,220,955 | 9/27/2020 |
2.10.1 | 1,604 | 9/24/2020 |
2.10.0 | 261,609 | 9/22/2020 |
2.9.1 | 2,413,391 | 8/4/2020 |
2.9.0 | 369,894 | 7/14/2020 |
2.8.0 | 533,699 | 6/23/2020 |
2.7.0 | 399,890 | 6/2/2020 |
2.6.1 | 343,230 | 5/19/2020 |
2.6.0 | 1,981,511 | 4/21/2020 |
2.5.0 | 305,147 | 3/16/2020 |
2.4.0 | 373,281 | 3/10/2020 |
2.3.0 | 400,906 | 2/18/2020 |
2.2.0 | 643,124 | 2/4/2020 |
2.1.2 | 386,755 | 1/7/2020 |
2.1.1 | 329,933 | 12/17/2019 |
2.1.0 | 511,751 | 11/26/2019 |
2.0.0 | 465,094 | 11/4/2019 |
1.15.0 | 1,032,872 | 10/15/2019 |
1.14.2 | 185,816 | 9/24/2019 |
1.14.1 | 319,276 | 8/27/2019 |
1.14.0 | 1,423 | 8/19/2019 |
1.13.1 | 392,413 | 7/30/2019 |
1.13.0 | 290,764 | 7/2/2019 |
1.12.0 | 176,058 | 6/18/2019 |
1.11.0 | 79,112 | 6/4/2019 |
1.10.0 | 72,593 | 5/6/2019 |
1.9.0 | 475,390 | 4/23/2019 |
1.8.0 | 54,462 | 4/9/2019 |
1.7.0 | 83,296 | 3/26/2019 |
1.5.0 | 56,049 | 3/12/2019 |
1.4.0 | 3,089 | 2/28/2019 |
1.3.0 | 43,542 | 2/26/2019 |
1.2.0 | 33,001 | 2/12/2019 |
1.1.1-preview | 4,163 | 1/30/2019 |
1.1.0 | 29,221 | 1/29/2019 |
1.0.1 | 73,235 | 1/15/2019 |
1.0.0 | 60,421 | 12/18/2018 |
0.7.0 | 12,530 | 12/4/2018 |
0.6.2 | 1,242 | 12/3/2018 |
0.6.1 | 8,720 | 11/21/2018 |
0.5.1 | 8,915 | 11/8/2018 |
0.5.0 | 1,728 | 11/6/2018 |
0.4.0 | 11,368 | 10/23/2018 |
0.3.0 | 11,125 | 10/9/2018 |
0.2.3 | 4,742 | 9/27/2018 |
0.2.2 | 881 | 9/24/2018 |
0.1.0 | 770 | 8/28/2018 |