How often do you have to run adhoc SQL scripts in prod?
The new development team has decided to write a new system to replace the old one and they frequently ask us to run ad-hoc SQL statements to clean up records and patch up issues caused by bugs.
In my ~8 years of working on the existing app, I can probably count on one hand the number of times we needed to run ad-hoc SQL scripts against production data (almost always after importing data from an other system), everything else was handled with migrations.
I'm seeing about 3-5 ad-hoc scripts needing to be run per-release. Just curious if this is at all normal or if I'm just expecting too much.
If you're wondering why I might have a problem with this at all, it's because at least 50% of the time there is also a problem with the SQL script and it either doesn't do the right thing or it has syntax errors. It feels like it was just "thrown over the wall".
1 comment
[ 2.0 ms ] story [ 13.3 ms ] thread