3 ms·
Every conversation I've ever had came back to using RedGate SQL Compare to diff databases and TeamCity for CI. You basically shouldn't allow anyone to modify a
by dwd 8y ago
Every conversation I've ever had came back to using RedGate SQL Compare to diff databases and TeamCity for CI.
You basically shouldn't allow anyone to modify anything without it being scripted (bonus points if it comes with a rollback and is repeatable for testing). Your scripts then all go into Git.
- RegBarclay 8y agoRedGate'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.