Free high performance migration to Fabric
Regular 50 minute session for SQLBits 2026Thursday - 23 Apr 2026 - 10:00 - 10:50 Room 1CTL; DR
A practical deep dive on migrating real SQL Server, Azure SQL, MI, and Synapse workloads. Covering both data and database code migration into Microsoft Fabric using free Spectral Core Fabric Migration, with concrete patterns, pitfalls, and validation steps.
Session Details
We will walk through what it actually takes to move a SQL-centric workload from SQL Server, Azure SQL, Managed Instance, or Synapse Dedicated SQL Pool into Fabric Warehouse and Lakehouse. You will see how schemas, objects, SQL, and stored procedures can be translated into Fabric-compatible formats, where Synapse-specific behavior needs targeted emulation or rewrites, and how to validate the migration before calling it done. We will also cover the data side of the move: handling large-scale transfers, reducing downtime, and avoiding the usual split between one tool for code conversion and another for data loading.
This session is aimed at SQLBits attendees who live in T-SQL, care about correctness and performance, and need to understand not just what is possible in Fabric, but what a credible migration path looks like in practice. Expect a concrete demo and discussion of what translates cleanly versus what still needs refactoring, and guidance you can use to plan or de-risk your first production migration to Fabric.
Learning outcomes
- Understand how a single workflow can migrate both data and database code into Microsoft Fabric for free
- See which source platforms are supported and what the limitations are
- Learn where automatic translation works well and where manual refactoring is still required for Fabric Warehouse compatibility.
- Understand how to approach correctness validation and performance checks
This session is aimed at SQLBits attendees who live in T-SQL, care about correctness and performance, and need to understand not just what is possible in Fabric, but what a credible migration path looks like in practice. Expect a concrete demo and discussion of what translates cleanly versus what still needs refactoring, and guidance you can use to plan or de-risk your first production migration to Fabric.
Learning outcomes
- Understand how a single workflow can migrate both data and database code into Microsoft Fabric for free
- See which source platforms are supported and what the limitations are
- Learn where automatic translation works well and where manual refactoring is still required for Fabric Warehouse compatibility.
- Understand how to approach correctness validation and performance checks
3 things you'll get out of this session
- See which source platforms are supported and what the limitations are
- Learn where automatic translation works well and where manual refactoring is still required for Fabric Warehouse compatibility.
- Understand how to approach correctness validation and performance checks
- Learn where automatic translation works well and where manual refactoring is still required for Fabric Warehouse compatibility.
- Understand how to approach correctness validation and performance checks