Is it possible to run a sql script while creating database from ARM Template

Question

Hello,

We are trying to create a sql database in azure using Azure Resource Group from Tempate using visual studio. We want to run a sql script after the creation of database so that the tables are created in database at run time only. Is there any way avaiable ??

Any help would be appricated.

Thanks!

Answer 1

Hi @Nishant Jain , welcome to Microsoft Q&A forum.

As I understand you want to deploy the schema of database at the time of server creation.

We can do it with the help of importing bacpac files with ARM templates. Firstly we need to create the bacpac file and then use the url of it in ARM template. Please refer to below article that has the details related to it:

Import SQL BACPAC files with ARM templates

Please refer to completed template and let us know if you face any issue or have any other queries.