This article is about moving resources to another subscription or another resource group in the same subscription. This can be done using Azure portal, PowerShell, Azure CLI or the REST API.
To move resources, the source resource group and the target resource group both are locked during the operation and resources can’t be added, updated, or deleted in the resource groups but they are not frozen. For example, if a SQL Server is moved to a new resource group, the applications using the database will not experience any downtime. They would still be able to access the database(s). However, changing the location of the resource is not possible.
View original post 233 more words
SQL Tutorials 