Using Octopus deploy and DbUp for updates to more than one database

Legacy Uncategorised
1

I am using DbUp and works fantastic when using one DB and one console application. Using multiple DB scripts in one console app did not work well or I did not set it up correctly. How do you propose to use DbUp when multiple DBs are in play?

Thanks,
Rashmi

2

Hi Rashmi,

Thanks for reaching out. Are these multiple databases going to get the same scripts, or does each haven their own set of scripts to be run on them?

Thanks,
Dalmiro

3

Hi Dalmiro,
Each DB needs its own set of scripts to be run on it. These DBs have different schemas.

Thanks,
Rashmi

4

Hi Rashmi,

If each database has their own set of scripts, I believe the best would be to have a VS Console project with DB up per database, a package per project and finally a deploy step per package.

Hope that helps,
Dalmiro

5

Thanks!