← Back to context

Comment by cloogshicer

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.