Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



Move Azure SQL Server and Azure SQL Database to a new Resource Group
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2015-12-14







To move an Azure SQL Database(as-a-service) to another Resource Group you must move
the top level resource first, which in this case is the SQL Server that the DB resides on.
Move the Azure SQL Server and the Azure SQL Database moves with it.



Solution:


Powershell:

$resource = Get-AzureRmResource -ResourceName srv-az-db-3 -ResourceGroupName rgAZDB1
Move-AzureRmResource -DestinationResourceGroupName TestResourceGroup -ResourceId $resource.ResourceId




Image #1: Powershell Confirm






Image #2: Azure Portal - Moving Resources