Azure SQL server Deplyoment using ARM to another Resource Group Schema not deplyoed

Question

HI All,

I have Azure SQL server with single database in a resource group. now we want to deploy in another resource group using ARM template. it is deploy but i didn't get schema( Table/View etc..) not show in new resource group

Answer 1

ARM template deployment will provision the server and database resources, but you will still need to run SQL scripts to create your schema. The ARM deployment only creates the containers, but it does not fill them. It is possible to use an ARM template to populate the database using a restore from backup if you have a suitable backup available in a Storage Account.