3 ms·
Would something like the Rails database migration systems work for this (aka a DSL for describing common db transformation tasks with tooling to put you at the
by michaelbuckbee 11y ago
Would something like the Rails database migration systems work for this (aka a DSL for describing common db transformation tasks with tooling to put you at the right version, rollbacks,etc.)
- jeffasinger 11y agoWhere I work we have a big directory with one file for each stored procedure. On deploy, all the stored procedures will get updated from that directory. Rolling back would consist of deploying an earlier version of the repository with the procedures in it.
- matwood 11y agoYears ago I wrote some custom scripts to do exactly this. Deploy consisted of having all of the sprocs migrate. At the time I also encrypted all of the sprocs because some admins had a hard time not making changes to live system instead of in source control.