AzureRM.Sql

4.12.2

Microsoft Azure PowerShell - Sql service cmdlets for Azure Resource Manager

Minimum PowerShell version

5.0

Installation Options

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

Install-Module -Name AzureRM.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

Author(s)

Microsoft Corporation

Copyright

Microsoft Corporation. All rights reserved.

Owners

Tags

Azure ResourceManager ARM Sql Database

Cmdlets

Get-AzureRmSqlDatabaseTransparentDataEncryption Get-AzureRmSqlDatabaseTransparentDataEncryptionActivity Set-AzureRmSqlDatabaseTransparentDataEncryption Get-AzureRmSqlDatabaseUpgradeHint Get-AzureRmSqlServerUpgradeHint Get-AzureRmSqlServerServiceObjective Get-AzureRmSqlServerUpgrade Start-AzureRmSqlServerUpgrade Stop-AzureRmSqlServerUpgrade Get-AzureRmSqlServerActiveDirectoryAdministrator Remove-AzureRmSqlServerActiveDirectoryAdministrator Set-AzureRmSqlServerActiveDirectoryAdministrator Get-AzureRmSqlServer New-AzureRmSqlServer Remove-AzureRmSqlServer Set-AzureRmSqlServer Get-AzureRmSqlServerCommunicationLink New-AzureRmSqlServerCommunicationLink Remove-AzureRmSqlServerCommunicationLink Get-AzureRmSqlDatabaseSecureConnectionPolicy Get-AzureRmSqlDatabaseReplicationLink New-AzureRmSqlDatabaseCopy New-AzureRmSqlDatabaseSecondary Remove-AzureRmSqlDatabaseSecondary Set-AzureRmSqlDatabaseSecondary Get-AzureRmSqlElasticPoolRecommendation Get-AzureRmSqlDatabaseIndexRecommendations Start-AzureRmSqlDatabaseExecuteIndexRecommendation Stop-AzureRmSqlDatabaseExecuteIndexRecommendation Get-AzureRmSqlServerFirewallRule New-AzureRmSqlServerFirewallRule Remove-AzureRmSqlServerFirewallRule Set-AzureRmSqlServerFirewallRule Get-AzureRmSqlElasticPool Get-AzureRmSqlElasticPoolActivity Get-AzureRmSqlElasticPoolDatabase New-AzureRmSqlElasticPool Remove-AzureRmSqlElasticPool Set-AzureRmSqlElasticPool Get-AzureRmSqlServerDisasterRecoveryConfiguration Get-AzureRmSqlServerDisasterRecoveryConfigurationActivity New-AzureRmSqlServerDisasterRecoveryConfiguration Remove-AzureRmSqlServerDisasterRecoveryConfiguration Set-AzureRmSqlServerDisasterRecoveryConfiguration Resume-AzureRmSqlDatabase Suspend-AzureRmSqlDatabase Get-AzureRmSqlDatabaseDataMaskingPolicy Get-AzureRmSqlDatabaseDataMaskingRule New-AzureRmSqlDatabaseDataMaskingRule Remove-AzureRmSqlDatabaseDataMaskingRule Set-AzureRmSqlDatabaseDataMaskingPolicy Set-AzureRmSqlDatabaseDataMaskingRule Get-AzureRmSqlCapability Get-AzureRmSqlServerThreatDetectionPolicy Remove-AzureRmSqlServerThreatDetectionPolicy Set-AzureRmSqlServerThreatDetectionPolicy Get-AzureRmSqlDatabaseThreatDetectionPolicy Set-AzureRmSqlDatabaseThreatDetectionPolicy Remove-AzureRmSqlDatabaseThreatDetectionPolicy Get-AzureRmSqlDatabase Get-AzureRmSqlDatabaseActivity Get-AzureRmSqlDatabaseExpanded New-AzureRmSqlDatabase Remove-AzureRmSqlDatabase Set-AzureRmSqlDatabase Get-AzureRmSqlDatabaseImportExportStatus New-AzureRmSqlDatabaseExport New-AzureRmSqlDatabaseImport Get-AzureRmSqlDatabaseGeoBackupPolicy Set-AzureRmSqlDatabaseGeoBackupPolicy Get-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Set-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Get-AzureRmSqlDatabaseLongTermRetentionBackup Remove-AzureRmSqlDatabaseLongTermRetentionBackup Get-AzureRmSqlDeletedDatabaseBackup Get-AzureRmSqlDatabaseGeoBackup Get-AzureRmSqlServerBackupLongTermRetentionVault Restore-AzureRmSqlDatabase Set-AzureRmSqlServerBackupLongTermRetentionVault Get-AzureRmSqlDatabaseRestorePoints Get-AzureRmSqlDatabaseAuditingPolicy Get-AzureRmSqlServerAuditingPolicy Get-AzureRmSqlDatabaseAuditing Get-AzureRmSqlServerAuditing Remove-AzureRmSqlDatabaseAuditing Remove-AzureRmSqlServerAuditing Set-AzureRmSqlDatabaseAuditingPolicy Set-AzureRmSqlServerAuditingPolicy Set-AzureRmSqlDatabaseAuditing Set-AzureRmSqlServerAuditing Use-AzureRmSqlServerAuditingPolicy Get-AzureRmSqlDatabaseRecommendedAction Get-AzureRmSqlElasticPoolRecommendedAction Get-AzureRmSqlServerRecommendedAction Set-AzureRmSqlDatabaseRecommendedActionState Set-AzureRmSqlElasticPoolRecommendedActionState Set-AzureRmSqlServerRecommendedActionState Get-AzureRmSqlElasticPoolAdvisor Get-AzureRmSqlServerAdvisor Set-AzureRmSqlElasticPoolAdvisorAutoExecuteStatus Set-AzureRmSqlServerAdvisorAutoExecuteStatus Get-AzureRmSqlDatabaseAdvisor Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus Get-AzureRmSqlServerTransparentDataEncryptionProtector Set-AzureRmSqlServerTransparentDataEncryptionProtector Add-AzureRmSqlServerKeyVaultKey Get-AzureRmSqlServerKeyVaultKey Remove-AzureRmSqlServerKeyVaultKey Get-AzureRmSqlDatabaseFailoverGroup New-AzureRmSqlDatabaseFailoverGroup Add-AzureRmSqlDatabaseToFailoverGroup Remove-AzureRmSqlDatabaseFromFailoverGroup Remove-AzureRmSqlDatabaseFailoverGroup Set-AzureRmSqlDatabaseFailoverGroup Switch-AzureRmSqlDatabaseFailoverGroup New-AzureRmSqlSyncGroup Update-AzureRmSqlSyncGroup Get-AzureRmSqlSyncGroup Get-AzureRmSqlSyncGroupLog Remove-AzureRmSqlSyncGroup Update-AzureRmSqlSyncSchema Get-AzureRmSqlSyncSchema Start-AzureRmSqlSyncGroupSync Stop-AzureRmSqlSyncGroupSync New-AzureRmSqlSyncMember Update-AzureRmSqlSyncMember Get-AzureRmSqlSyncMember Remove-AzureRmSqlSyncMember New-AzureRmSqlSyncAgent Get-AzureRmSqlSyncAgent Remove-AzureRmSqlSyncAgent New-AzureRmSqlSyncAgentKey Get-AzureRmSqlSyncAgentLinkedDatabase New-AzureRmSqlServerVirtualNetworkRule Set-AzureRmSqlServerVirtualNetworkRule Get-AzureRmSqlServerVirtualNetworkRule Remove-AzureRmSqlServerVirtualNetworkRule Stop-AzureRmSqlDatabaseActivity Get-AzureRmSqlServerDnsAlias Remove-AzureRmSqlServerDnsAlias New-AzureRmSqlServerDnsAlias Set-AzureRmSqlServerDnsAlias New-AzureRmSqlDatabaseRestorePoint Remove-AzureRmSqlDatabaseRestorePoint Stop-AzureRmSqlElasticPoolActivity Add-AzureRmSqlServerTransparentDataEncryptionCertificate Add-AzureRmSqlManagedInstanceTransparentDataEncryptionCertificate Enable-AzureRmSqlServerAdvancedThreatProtection Disable-AzureRmSqlServerAdvancedThreatProtection Get-AzureRmSqlServerAdvancedThreatProtectionPolicy Update-AzureRmSqlDatabaseVulnerabilityAssessmentSettings Get-AzureRmSqlDatabaseVulnerabilityAssessmentSettings Clear-AzureRmSqlDatabaseVulnerabilityAssessmentSettings Set-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline Get-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline Convert-AzureRmSqlDatabaseVulnerabilityAssessmentScan Get-AzureRmSqlDatabaseVulnerabilityAssessmentScanRecord Start-AzureRmSqlDatabaseVulnerabilityAssessmentScan Get-AzureRmSqlInstance New-AzureRmSqlInstance Remove-AzureRmSqlInstance Set-AzureRmSqlInstance Get-AzureRmSqlInstanceDatabase New-AzureRmSqlInstanceDatabase Remove-AzureRmSqlInstanceDatabase Restore-AzureRmSqlInstanceDatabase

Dependencies

Release Notes

Microsoft Azure PowerShell - Sql service cmdlets.
This module is outdated and will go out of support on 29 February 2024.
The Az.Sql module has all the capabilities of AzureRM.Sql and provides the following improvements:
* Az.Sql takes advantage of greater security with token cache encryption and improved authentication.
* Availability in Azure Cloud Shell and on Linux and macOS.
We encourage you to start using the Az module as soon as possible to take advantage of these improvements.
[Update your scripts](https://aka.ms/azpsmigrate) that use AzureRM PowerShell modules to use Az PowerShell modules by 29 February 2024. To automatically update your scripts, follow the [quickstart guide](https://aka.ms/azpsmigratequick).

Version History

Version Downloads Last updated
4.12.2 (current version) 1,341,230 3/23/2021
4.12.1 6,516,757 11/21/2018
4.11.6-preview 462 11/7/2018
4.11.5 220,846 10/9/2018
4.11.4-preview 138 9/24/2018
4.11.3 399,639 8/29/2018
4.11.1 104,757 8/14/2018
4.11.0 66,742 7/31/2018
4.10.0 91,388 7/3/2018
4.9.0 56,472 7/3/2018
4.8.1-preview 880 6/13/2018
4.8.0-preview 49 6/12/2018
4.7.0-preview 86 6/8/2018
4.6.1 113,747 6/19/2018
4.6.0 77,111 6/5/2018
4.5.0 57,242 5/22/2018
4.5.0-preview 219 5/9/2018
4.4.1 62,618 5/7/2018
4.4.0 431,448 4/10/2018
4.3.1 59,170 3/27/2018
4.3.0 50,719 3/13/2018
4.2.0 193,207 1/31/2018
4.1.1 128,756 12/9/2017
4.0.1 59,915 11/10/2017
4.0.0 37,354 11/8/2017
3.4.1 224,485 10/12/2017
3.4.0 130,492 9/25/2017
3.3.1 83,484 8/16/2017
3.2.1 40,780 7/18/2017
3.2.0 6,303 7/11/2017
3.1.0 42,081 6/8/2017
3.0.1 20,738 5/24/2017
3.0.0 19,505 5/10/2017
2.8.0 50,169 4/5/2017
2.7.0 27,182 3/9/2017
2.6.0 14,842 2/22/2017
2.5.0 27,858 1/18/2017
2.4.0 17,270 12/14/2016
2.3.0 27,350 11/2/2016
2.2.0 13,272 9/28/2016
2.1.0 36,761 9/8/2016
2.0.1 7,954 8/10/2016
2.0.0 510 8/8/2016
1.0.11 25,903 7/12/2016
1.0.10 3,411 6/27/2016
1.0.9 5,982 6/1/2016
1.0.8 8,778 5/4/2016
1.0.7 3,622 4/19/2016
1.0.6 5,228 3/30/2016
1.0.5 4,373 3/4/2016
1.0.4.4 15,507 7/8/2017
1.0.4.3 22,438 3/14/2017
1.0.4.2 8,503 1/4/2017
1.0.4.1 118,238 9/8/2016
1.0.4 4,747 2/3/2016
1.0.3 2,792 1/13/2016
1.0.2 1,583 12/16/2015
1.0.1 2,815 11/9/2015
1.0.0 239 11/6/2015
0.10.0 1,772 10/9/2015