Azure Resource Group: Run sql script for SQL Database

0
votes

I am working on Azure Resource Group. I managed to deploy sql database to azure. However, I cannot figure out the way to run sql script during the deployment process for that database. Anyone knows how to do it?

1
azureazure-sql-databaseazure-resource-group
Kim - what deployment process are you using to deploy your resource group? - Dan Rediske
When you say deploy SQL database to azure, I'm assuming you mean through the portal, where you apply a dacpac. If you want to run a sql script, you're going to want to check out my post earlier today about how to deploy using SSDT. stackoverflow.com/questions/39209534/… - Shannon Lowder

1 Answers

1
votes

You should be able to run it directly against the Azure SQL Database through it's connection string (you can get that on Azure Portal)

Also gotta make sure you have the firewall permissions for properly accessing the Azure SQL Database