Comment by cloogshicer
2 years ago
Genuinely curious (I don't have much experiences with DBs), how is schema migration done 'properly' these days?
2 years ago
Genuinely curious (I don't have much experiences with DBs), how is schema migration done 'properly' these days?
Incremental 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.
Are you talking about the mechanics? Like more than just run a migration script on boot?