Deploy dacpac to azure database

[phil.johnson]

i have a .sqlproj folder that i deploy to a production database much like how it’s specified in here: https://kwilson.io/blog/deploy-a-database-project-dacpac-using-octopusdeploy-and-powershell/ . it works great, but now i need to be able to deploy to an azure database, and i’m at a loss for the best way to proceed. Any ideas/suggestions?

[Kenneth_Bates]

Hi Phil,

Thanks for getting in touch! Deploying to an Azure database should work basically the same as you have been doing with just changing the connection strings. Are you hitting any issues when attempting the dacpac deployment to Azure?

Let me know how you go and if you have any further questions.

Kind regards,

Kenny