Microsoft now offers the Fabric Migration Assistant for Data Warehouse. For teams on Azure Synapse dedicated SQL pools, it copies metadata and data into a Fabric Data Warehouse and converts the source schema automatically. AI-powered suggestions help with incompatibilities during the move.
That covers the warehouse. A migration also has to cover everything connected to it. Microsoft's own guide ends with a step called Reroute connections: finding every report and pipeline that points at the old warehouse, testing it against the new one, and switching it over.
What we plan for on every Synapse-to-Fabric move:
- An inventory: tables, stored procedures, pipelines, reports and who owns each.
- One proof report the business trusts, where old and new numbers must match.
- Pipelines rebuilt or repointed, with schedules and monitoring.
- A cut-over plan with a rollback window.
- Decisions on what to modernize now (for example, moving logic into Fabric pipelines) and what to move as it is.
The Migration Assistant handles the warehouse itself. The rest of that list is where projects slip, and where planning pays off.
