Database deployment in Azure DevOps

Question

We are using DbUp migration task (https://marketplace.visualstudio.com/items?itemName=johanclasson.UpdateDatabaseWithDbUp) for deploying the SQL scripts to Microsoft SQL server in Azure DevOps and this works perfectly fine when I need to deploy to a single database but could someone please help me how can I use this task for multiple databases in the same server or any other methods we can use for multiple databases.

Answer 1

It all depends how you have your scripts organized. However, assuming that you have scripts separated by database - each database has it's own folder than what yout need is just provider proper value for Script Folder Path and proper connection string with database. In this case it will endup in having one task per database.