4 ms·
RedGate's SQL Change Automation (formerly ReadyRoll) is pretty slick. DbUp is a good, free alternative. I second the rollback and repeatability bonus. Every sc
by RegBarclay 8y ago
RedGate's SQL Change Automation (formerly ReadyRoll) is pretty slick. DbUp is a good, free alternative.
I second the rollback and repeatability bonus. Every script should leave the database in either the new state or the previous good state no matter how many times it's run.
- beefield 8y ago> Every script should leave the database in either the new state or the previous good state no matter how many times it's run. I wonder if there were somewhere a website to describe good idioms to achieve this?
- dwd 8y agoWhere I've seen this process work, testing for repeatability was part of the peer review process where any sql scripts to be reviewed were executed. Having a second person run a script is the best way to ensure no mistakes.