Az.Sql

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

Installation Options

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

Install-Module -Name Az.Sql -RequiredVersion 4.1.0

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

Author(s)

Microsoft Corporation

Copyright

Microsoft Corporation. All rights reserved.

Package Details

Owners

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

PSEditions

Core Desktop

Dependencies

Release Notes

* Added new cmdlets for CRUD operations on SQL server IPv6 Firewall rules
     'Get-AzSqlServerIpv6FirewallRule'
     'New-AzSqlServerIpv6FirewallRule'
     'Remove-AzSqlServerIpv6FirewallRule'
     'Set-AzSqlServerIpv6FirewallRule'
* StorageContainerSasToken parameter in the 'Start-AzSqlInstanceDatabaseLogReplay' cmdlet is now optional

FileList

Version History

Version Downloads Last updated
4.3.0 94,404 2/7/2023
4.2.0 1,042,206 1/10/2023
4.1.0 (current version) 2,300,564 11/1/2022
4.0.0 489,026 10/17/2022
3.11.0 2,310,347 8/2/2022
3.10.0 690,324 7/5/2022
3.9.0 1,821,775 5/24/2022
3.8.0 1,773,696 4/5/2022
3.7.1 1,136,779 2/7/2022
3.7.0 674,926 1/4/2022
3.6.0 446,201 12/7/2021
3.5.1 1,878,297 10/12/2021
3.5.0 758,927 9/7/2021
3.4.1 664,333 7/15/2021
3.4.0 500,703 7/6/2021
3.3.0 13,302 6/23/2021
3.2.0 389,164 6/15/2021
3.1.0 402,413 5/25/2021
3.0.0-preview 717 3/27/2021
2.17.1 2,261,845 4/13/2021
2.17.0 598,386 3/23/2021
2.16.0 1,346,904 2/9/2021
2.15.0 1,659,364 1/19/2021
2.14.0 1,448,412 12/29/2020
2.13.0 1,382,399 12/8/2020
2.12.0 1,615,560 11/17/2020
2.11.1 1,719,566 10/27/2020
2.11.0 2,491,264 9/27/2020
2.10.1 1,602 9/24/2020
2.10.0 231,345 9/22/2020
2.9.1 2,360,529 8/4/2020
2.9.0 350,641 7/14/2020
2.8.0 509,413 6/23/2020
2.7.0 389,515 6/2/2020
2.6.1 315,941 5/19/2020
2.6.0 1,761,369 4/21/2020
2.5.0 304,700 3/16/2020
2.4.0 369,284 3/10/2020
2.3.0 353,511 2/18/2020
2.2.0 592,980 2/4/2020
2.1.2 363,741 1/7/2020
2.1.1 329,864 12/17/2019
2.1.0 480,729 11/26/2019
2.0.0 464,824 11/4/2019
1.15.0 883,535 10/15/2019
1.14.2 185,592 9/24/2019
1.14.1 311,823 8/27/2019
1.14.0 1,417 8/19/2019
1.13.1 362,840 7/30/2019
1.13.0 290,499 7/2/2019
1.12.0 170,286 6/18/2019
1.11.0 79,019 6/4/2019
1.10.0 71,893 5/6/2019
1.9.0 464,872 4/23/2019
1.8.0 54,416 4/9/2019
1.7.0 78,804 3/26/2019
1.5.0 56,038 3/12/2019
1.4.0 2,606 2/28/2019
1.3.0 43,434 2/26/2019
1.2.0 32,607 2/12/2019
1.1.1-preview 3,982 1/30/2019
1.1.0 29,200 1/29/2019
1.0.1 73,212 1/15/2019
1.0.0 56,121 12/18/2018
0.7.0 12,497 12/4/2018
0.6.2 1,240 12/3/2018
0.6.1 8,717 11/21/2018
0.5.1 8,912 11/8/2018
0.5.0 1,725 11/6/2018
0.4.0 11,365 10/23/2018
0.3.0 11,122 10/9/2018
0.2.3 4,739 9/27/2018
0.2.2 878 9/24/2018
0.1.0 751 8/28/2018
Show more