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.
I never saw a successful fully automated one-way-of-doing process.