Az.Sql

4.14.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

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name Az.Sql

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

Install-PSResource -Name Az.Sql

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

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

Core Desktop

Dependencies

Release Notes

* Added 'DatabaseFormat' and 'PricingModel' parameters to 'New-AzSqlInstance', 'Set-AzSqlInstance'
* Added breaking change message for 'New-AzSqlDatabaseFailoverGroup' and 'Set-AzSqlDatabaseFailoverGroup'
   - The default value of 'FailoverPolicy' parameter will be changed from 'Automatic' to 'Manual'
* Added a new cmdlet for Azure SQL Managed Instance refresh external governance status
 - 'Invoke-AzSqlInstanceExternalGovernanceStatusRefresh'
* Updated 'Get-AzSqlInstance' to support returning the 'ExternalGovernanceStatus' property

FileList

Version History

Version Downloads Last updated
4.14.0 (current version) 4,746,300 2/6/2024
4.13.0 1,521,014 1/9/2024
4.12.0 1,644,246 12/5/2023
4.11.0 1,168,280 11/14/2023
4.10.0 3,715,351 9/5/2023
4.9.0 1,393,494 8/1/2023
4.8.0 1,192,544 7/4/2023
4.7.0 1,564,679 5/23/2023
4.6.0 1,909,727 4/25/2023
4.5.0 841,122 4/4/2023
4.4.0 1,135,652 3/9/2023
4.3.0 1,224,935 2/7/2023
4.2.0 1,239,771 1/10/2023
4.1.0 2,404,922 11/1/2022
4.0.0 816,748 10/17/2022
3.11.0 2,699,959 8/2/2022
3.10.0 707,667 7/5/2022
3.9.0 3,898,529 5/24/2022
3.8.0 3,447,815 4/5/2022
3.7.1 1,193,996 2/7/2022
3.7.0 708,001 1/4/2022
3.6.0 520,992 12/7/2021
3.5.1 2,471,097 10/12/2021
3.5.0 792,896 9/7/2021
3.4.1 692,293 7/15/2021
3.4.0 596,994 7/6/2021
3.3.0 13,307 6/23/2021
3.2.0 399,407 6/15/2021
3.1.0 412,574 5/25/2021
3.0.0-preview 721 3/27/2021
2.17.1 3,162,262 4/13/2021
2.17.0 672,283 3/23/2021
2.16.0 1,440,235 2/9/2021
2.15.0 1,661,417 1/19/2021
2.14.0 1,470,325 12/29/2020
2.13.0 1,395,312 12/8/2020
2.12.0 1,633,441 11/17/2020
2.11.1 1,721,068 10/27/2020
2.11.0 3,139,750 9/27/2020
2.10.1 1,604 9/24/2020
2.10.0 259,907 9/22/2020
2.9.1 2,407,296 8/4/2020
2.9.0 369,015 7/14/2020
2.8.0 533,446 6/23/2020
2.7.0 399,023 6/2/2020
2.6.1 343,193 5/19/2020
2.6.0 1,966,751 4/21/2020
2.5.0 305,117 3/16/2020
2.4.0 373,021 3/10/2020
2.3.0 398,696 2/18/2020
2.2.0 638,006 2/4/2020
2.1.2 385,143 1/7/2020
2.1.1 329,933 12/17/2019
2.1.0 505,912 11/26/2019
2.0.0 464,988 11/4/2019
1.15.0 1,022,230 10/15/2019
1.14.2 185,799 9/24/2019
1.14.1 318,940 8/27/2019
1.14.0 1,423 8/19/2019
1.13.1 390,330 7/30/2019
1.13.0 290,760 7/2/2019
1.12.0 175,862 6/18/2019
1.11.0 79,098 6/4/2019
1.10.0 72,566 5/6/2019
1.9.0 474,482 4/23/2019
1.8.0 54,449 4/9/2019
1.7.0 83,202 3/26/2019
1.5.0 56,047 3/12/2019
1.4.0 3,036 2/28/2019
1.3.0 43,542 2/26/2019
1.2.0 33,000 2/12/2019
1.1.1-preview 4,157 1/30/2019
1.1.0 29,219 1/29/2019
1.0.1 73,235 1/15/2019
1.0.0 60,306 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
Show more