The four things you are moving
Data, logic, consumption and operations have different owners, methods and failure modes.
It helps to separate the migration into four layers, because they have different owners, different methods and different failure modes.
| Layer | What it contains | Moved by |
|---|---|---|
| Data | Tables, partitions, history, large objects | The migration method you choose |
| Logic | Loading pipelines, procedural code, transformation SQL, scheduling | Conversion and re-implementation, not migration |
| Consumption | Reports, semantic models, extracts, downstream feeds, ad-hoc SQL | Re-pointing, re-testing, and negotiation with owners |
| Operations | Monitoring, runbooks, entitlements, support routes, batch calendar | Rebuilt on the new platform’s terms |
The method selection discussion that follows is about the first layer only. It is the one with genuine technical alternatives. The other three are largely determined by decisions you have already made — what you chose to rebuild, what the target design looks like, and which BI platform you are keeping.
The reason to lay this out early is that method comparisons that only consider the data layer produce confident answers to the wrong question.