3 ms·
Genuinely curious (I don't have much experiences with DBs), how is schema migration done 'properly' these days?
by cloogshicer 3y ago
Genuinely curious (I don't have much experiences with DBs), how is schema migration done 'properly' these days?
- jspdown 3y agoIncremental forward-only migrations (non-state based). Then, for the How and When, it mostly depends of your constraints and sizes. There's no silver bullet, it's hard, it require constant thinking, it's a slow and often multi step process. I never saw a successful fully automated one-way-of-doing process.
- from-nibly 3y agoAre you talking about the mechanics? Like more than just run a migration script on boot?