Happy New Year everyone :) I was curious what are the best practices these days for doing data base upgrades.
We currently use DbUp and we write all upgrade scripts by hand to allow us to verify them, tweak them, make sure upgrades work well. All scripts are idempotent and they can be run as many times as we want with no side effects. I generally dislike generated code or automatic DB upgrades as the schema we have is relatively large and don't want unknown small changes to slip through. How do you do your SQL upgrades? How could I improve mine? Thanks, Corneliu.