Use bicep to move sql server

Question

Can we use bicep to move sql server from one resource group to another resource group? I have a sql server in resource group A, and I want to move this sql server to resource group B, both resource group are under same subscription.

Answer 1

It is indeed not possible by bicep. But it possible to move the SQL server through the portal.

1. Navigate to the SQL server you want to move
2. Select Move > Move to another resource group
   
3. Then a wizard starts to select the source and target destination

It should also possible with the Azure resource mover, but I don't have any experience with this. More info: https://learn.microsoft.com/en-us/azure/resource-mover/tutorial-move-region-sql

Kind Regards,

Wilko

---

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".

Answer 2

Hi, This is not possible. Bicep is Infrastructure as code (IaC) where moving a resource from one resource group to another is more like operation rather configuring state. Similar things that are operation are start or stopping a VM or other resource, etc. Of course you can always use deploymentScripts resources which allows you to execute PowerShell/Az CLI scripts but at the end you will still write a script for that not so much Bicep code.

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.