AzureRM.Sql

Author(s)

• Microsoft Corporation

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 Get-AzureRmSqlDatabaseInstanceFailoverGroup New-AzureRmSqlDatabaseInstanceFailoverGroup Remove-AzureRmSqlDatabaseInstanceFailoverGroup Set-AzureRmSqlDatabaseInstanceFailoverGroup Switch-AzureRmSqlDatabaseInstanceFailoverGroup 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 Get-AzureRmSqlManagedInstance New-AzureRmSqlManagedInstance Remove-AzureRmSqlManagedInstance Set-AzureRmSqlManagedInstance Update-AzureRmSqlManagedInstance Get-AzureRmSqlManagedDatabase New-AzureRmSqlManagedDatabase Remove-AzureRmSqlManagedDatabase Restore-AzureRmSqlManagedDatabase

Dependencies

• • AzureRM.Profile (>= 5.0.0)

Release Notes

* Added new cmdlets for CRUD operations on Managed Instance and Managed Database
* Add commandlets for new feature - Instance Failover Groups
- Get-AzureRmSqlDatabaseInstanceFailoverGroup get the Instance Failover Group entity
- New-AzureRmSqlDatabaseInstanceFailoverGroup creates a new Instance Failover Group
- Remove-AzureRmSqlDatabaseInstanceFailoverGroup Instance Failover Group deletes the Failover Group
- Set-AzureRmSqlDatabaseInstanceFailoverGroup set Azure Sql Database Failover Policy and Grace Period entities of the Instance Failover Group
- Switch-AzureRmSqlDatabaseInstanceFailoverGroup issues the failover operation with data loss or without data loss
* Updated Auditing cmdlets to allow removing AuditActions or AuditActionGroups
* Fixed issue with Set-AzureRmSqlDatabaseBackupLongTermRetentionPolicy when setting a new flexible retention policy where the command would fail with "Configure long term retention policy with azure recovery service vault and policy is no longer supported. Please submit request with the new flexible retention policy".