AzureRM.Sql

2.6.0

Microsoft Azure PowerShell - Sql service cmdlets for Azure Resource Manager

Minimum PowerShell version

3.0

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

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

Install-Module -Name AzureRM.Sql -RequiredVersion 2.6.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-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-AzureRmSqlDeletedDatabaseBackup Get-AzureRmSqlDatabaseGeoBackup Get-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Get-AzureRmSqlServerBackupLongTermRetentionVault Restore-AzureRmSqlDatabase Set-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Set-AzureRmSqlServerBackupLongTermRetentionVault Get-AzureRmSqlDatabaseRestorePoints Get-AzureRmSqlDatabaseAuditingPolicy Get-AzureRmSqlServerAuditingPolicy Remove-AzureRmSqlDatabaseAuditing Remove-AzureRmSqlServerAuditing Set-AzureRmSqlDatabaseAuditingPolicy Set-AzureRmSqlServerAuditingPolicy 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

Dependencies

Release Notes

* Adding new cmdlets for support for Azure SQL feature Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) Support
- TDE with BYOK support is a new feature in Azure SQL, which allows users to encrypt their database with a key from Azure Key Vault. This feature is currently in private preview.
- Get-AzureRmSqlServerKeyVaultKey : This cmdlet returns a list of Azure Key Vault keys added to a Sql Server.
- Add-AzureRmSqlServerKeyVaultKey : This cmdlet adds an Azure Key Vault key to a Sql Server.
- Remove-AzureRmSqlServerKeyVaultKey : This cmdlet removes an Azure Key Vault key from a Sql Server.
- Get-AzureRmSqlServerTransparentDataEncryptionProtector : This cmdlet returns the current encryption protector for a Sql Server.
- Set-AzureRmSqlServerTransparentDataEncryptionProtector : This cmdlet sets the encryption protector for a Sql Server. The encryption protector can be set to a key from Azure Key Vault or a key that is managed by Azure Sql.
* New feature: Set--AzureRmSqlDatabaseAuditing  and Set-AzureRmSqlDatabaseServerAuditingPolicy supports setting secondary storage key for AuditType Blob
* Bug fix: Remove-AzureRmSqlDatabaseAuditing should set the UseServerDefault value to disabled
* Bug fix: Fixing an issue of selecting classic storage account when creating / updating Auditing or Threat Detection policies
* Bug fix: Set-AzureRmSqlDatabaseAuditing and Set-AzureRmSqlDatabaseServerAuditingPolicy commands use the AuditType value that was previously defined in case it has not been configured by the user.
* Bug fix: In case Blob Auditing is defined, Remove-AzureRmSqlDatabaseAuditing and Remove-AzureRmSqlDatabaseServerAuditingPolicy commands disable the Auditing settings.
* Adding new cmdlets for support for Azure SQL feature AutoDR:
 -This is a new feature in Azure SQL that supports failover of multiple Azure Sql Databases to the partner server at the same time during disaster and allows automatic failover
 - Add-AzureRmSqlDatabaseToFailoverGroup add Azure Sql Databases into a Failover Group
 - Get-AzureRmSqlDatabaseFailoverGroup get the Failover Group entity
 - New-AzureRmSqlDatabaseFailoverGroup creates a new Failover Group
 - Remove-AzureRmSqlDatabaseFromFailoverGroup removes Azure Sql Databases from a Failover Group
 - Remove-AzureRmSqlDatabaseFailoverGroup Failover Group deletes the Failover Group
 - Set-AzureRmSqlDatabaseFailoverGroup set Azure Sql Database Failover Policy and Grace Period entities of the Failover Group
 - Switch-AzureRmSqlDatabaseFailoverGroup issues the failover operation with data loss or without data loss  

FileList

Version History

Version Downloads Last updated
4.12.2 10,571,666 3/23/2021
4.12.1 6,674,879 11/21/2018
4.11.6-preview 505 11/7/2018
4.11.5 222,086 10/9/2018
4.11.4-preview 176 9/24/2018
4.11.3 402,125 8/29/2018
4.11.1 142,099 8/14/2018
4.11.0 66,789 7/31/2018
4.10.0 91,483 7/3/2018
4.9.0 59,016 7/3/2018
4.8.1-preview 916 6/13/2018
4.8.0-preview 82 6/12/2018
4.7.0-preview 118 6/8/2018
4.6.1 114,316 6/19/2018
4.6.0 78,838 6/5/2018
4.5.0 58,354 5/22/2018
4.5.0-preview 251 5/9/2018
4.4.1 62,910 5/7/2018
4.4.0 446,226 4/10/2018
4.3.1 59,306 3/27/2018
4.3.0 50,801 3/13/2018
4.2.0 195,338 1/31/2018
4.1.1 130,582 12/9/2017
4.0.1 60,164 11/10/2017
4.0.0 37,418 11/8/2017
3.4.1 229,424 10/12/2017
3.4.0 142,500 9/25/2017
3.3.1 83,570 8/16/2017
3.2.1 41,573 7/18/2017
3.2.0 6,340 7/11/2017
3.1.0 42,168 6/8/2017
3.0.1 20,807 5/24/2017
3.0.0 19,553 5/10/2017
2.8.0 51,004 4/5/2017
2.7.0 27,303 3/9/2017
2.6.0 (current version) 14,884 2/22/2017
2.5.0 28,155 1/18/2017
2.4.0 17,312 12/14/2016
2.3.0 27,408 11/2/2016
2.2.0 13,315 9/28/2016
2.1.0 65,661 9/8/2016
2.0.1 7,995 8/10/2016
2.0.0 549 8/8/2016
1.0.11 25,959 7/12/2016
1.0.10 3,452 6/27/2016
1.0.9 6,023 6/1/2016
1.0.8 9,713 5/4/2016
1.0.7 3,661 4/19/2016
1.0.6 5,266 3/30/2016
1.0.5 4,412 3/4/2016
1.0.4.4 15,547 7/8/2017
1.0.4.3 22,490 3/14/2017
1.0.4.2 8,546 1/4/2017
1.0.4.1 122,144 9/8/2016
1.0.4 4,787 2/3/2016
1.0.3 2,856 1/13/2016
1.0.2 1,623 12/16/2015
1.0.1 2,856 11/9/2015
1.0.0 279 11/6/2015
0.10.0 1,813 10/9/2015
Show less