All posts
Microsoft Data Platform

Azure Synapse in 2026: Move to Fabric, Stay, or Take the Warehouse to AWS

By

October 25, 2026

6 min read

Microsoft has not retired Azure Synapse dedicated SQL pools, but it points every new warehouse at Fabric and ships a migration assistant for Synapse. When moving to Fabric makes sense, when staying is fine, and when a company whose applications are on AWS should move the warehouse there instead.

Azure Synapse
Microsoft Fabric
Data Warehouse
Redshift
Migration

Microsoft's guidance is that new warehouses should start on Fabric Data Warehouse, and existing Synapse dedicated SQL pool workloads can upgrade to Fabric for its newer capabilities. There is a Fabric Migration Assistant for Data Warehouse that converts dedicated pool artifacts. Dedicated SQL pools themselves are not being retired; some surrounding pieces have been, such as the Synapse Data Explorer preview in October 2025.

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

Three options

Option

Fits when

Tradeoff

Stay on Synapse

The warehouse is stable, the team knows it, nothing new is planned

New features land in Fabric, not Synapse

Move to Fabric

You are on Microsoft 365 and Power BI, and want warehouse, lakehouse and BI on one capacity

Capacity-based pricing shared between data jobs and report users; a newer product still changing quickly

Move to AWS

Applications and source data are on AWS; the warehouse is the main thing keeping you in Azure

A real migration: schema, pipelines (Data Factory to Glue or Step Functions) and BI connections

If you move to AWS

  • Redshift for the warehouse, or Iceberg tables in S3 queried by Athena and Redshift if you want an open format.

  • Zero-ETL from Aurora, RDS and DynamoDB removes the pipelines that copied application data into the warehouse.

  • Power BI can stay. It connects to Redshift and Athena, so BI can move later or never.

  • Move pipelines last. Rebuild them against the new warehouse rather than translating Data Factory pipelines one to one.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.