AzureRM.Sql

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

Dependencies

Release Notes

* Add Data Sync PowerShell Cmdlets to AzureRM.Sql
* Updated AzureRmSqlServer cmdlets to use new REST API version that avoids timeouts when creating server.
* Deprecated server upgrade cmdlets because the old server version (2.0) no longer exists.
* Add new optional switch paramter "AssignIdentity" to New-AzureRmSqlServer and Set-AzureRmSqlServer cmdlets to support provisioning of a resource identity for the SQL server resource
* The parameter ResourceGroupName is now optional for Get-AzureRmSqlServer
- More information can be found in the following issue: https://github.com/Azure/azure-powershell/issues/635

FileList

Version History

Version Downloads Last updated
4.12.2 10,493,979 3/23/2021
4.12.1 6,674,607 11/21/2018
4.11.6-preview 505 11/7/2018
4.11.5 222,085 10/9/2018
4.11.4-preview 176 9/24/2018
4.11.3 402,106 8/29/2018
4.11.1 142,083 8/14/2018
4.11.0 66,789 7/31/2018
4.10.0 91,483 7/3/2018
4.9.0 58,996 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,314 6/19/2018
4.6.0 78,821 6/5/2018
4.5.0 58,354 5/22/2018
4.5.0-preview 251 5/9/2018
4.4.1 62,907 5/7/2018
4.4.0 446,210 4/10/2018
4.3.1 59,306 3/27/2018
4.3.0 50,801 3/13/2018
4.2.0 195,327 1/31/2018
4.1.1 130,573 12/9/2017
4.0.1 60,164 11/10/2017
4.0.0 37,418 11/8/2017
3.4.1 229,417 10/12/2017
3.4.0 142,441 9/25/2017
3.3.1 83,570 8/16/2017
3.2.1 41,572 7/18/2017
3.2.0 (current version) 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 50,998 4/5/2017
2.7.0 27,303 3/9/2017
2.6.0 14,884 2/22/2017
2.5.0 28,154 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,479 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,710 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,142 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