johanclasson / vso-agent-tasks

Build and Release Tasks for Visual Studio Online and Team Foundation Server
MIT License
20 stars 16 forks source link

DbUp migration - Support for deployment to multiple database #73

Closed Pooja-graafika closed 2 years ago

Pooja-graafika commented 2 years ago

This works perfectly fine for a single database but for my requirement I need to deploy to multiple database instances in the same server, Please assist what changes can be done to achieve this.

73

sumo300 commented 2 years ago

Use multiple tasks that each target a different database on the same server and use the same set of files to execute the migration.

Pooja-graafika commented 2 years ago

Use multiple tasks that each target a different database on the same server and use the same set of files to execute the migration.

But there can be only one variable DbUp.Database for the release pipeline and in that case having multiple tasks would not work right? PFA the image. Can I directly add the database name in the task itself directly instead of using it as a variable?Please assist. DbUp

johanclasson commented 2 years ago

Then use other variables for the tasks, or if you wish enter the DbName directly in the task.