Fabric Data Warehouse Migration Assistant: Better, Faster, More Reliable
Building on the excitement of our public preview, we’re excited to announce the latest updates to the Migration Assistant for Fabric Data Warehouse, making it even easier, faster, and more reliable to move your data to Fabric. The Migration Assistant simplifies what can be a complicated process by automatically taking care of it. Since its launch, thousands of individuals and organizations have used the tool, with feedback helping us improve it for everyone. From early adopters to enterprise-scale migrations, the assistant is already helping teams accelerate their transition to Fabric. And now, it’s getting even better.
SQL Surface
This release introduces a robust set of autofix capabilities in Migration Assistant to streamline SQL migrations to Microsoft Fabric Data Warehouse. The tool now automatically resolves a wide range of unsupported SQL constructs, including:
- Removal of with options, on clauses, optimizer hints, and table hints.
- Elimination of unsupported constraints such as ROWGUIDCOL, unique, primary key, foreign key, and default constraints.
- Conversion of materialized views to CREATE TABLE AS SELECT (CTAS) statements
- Translation of merge statements into equivalent insert, update and delete operations.
- Enforcement of Fabric-specific rules such as requiring foreign keys and unique constraints to be not enforced and non-clustered.
- Removal of unsupported statements like ALTER TABLE SWITCH, recursive CTEs, and XML data types.
Coming soon
Support for identity columns, scalar functions, and temporary tables.
Intelligence
The assistant now applies smart logic to suggest fixes and highlight dependencies, reducing manual effort and helping you make informed decisions faster. It also flags unsupported patterns with clear error or warning messages, helping you quickly identify and resolve issues.
User Experience
- Progress tracking: View detailed stages of metadata migration as they happen.
- Summary view: View a comprehensive summary of how many objects migrated successfully and which need attention.
- Hover insights: View breakdowns by object type and view downstream dependencies.
- Full-screen view: View open migration summary in full screen view for better readability and navigation.
- Fix problems panel: View primary and dependent objects needing fixes, with filtering by object or issue type.
The Migration Assistant for Fabric Data Warehouse provides a robust solution for organizations aiming to migrate their data smoothly and efficiently. By utilizing performance improvements and intuitive interfaces, this tool reduces the complexities and potential challenges associated with data migration.
Next steps
We want to hear from you. Use the in-product feedback menu to tell us what’s working—and what’s not. For example, if you’re using the assistant for migration, let us know what went well and where you experienced friction.
You can also submit ideas through the Ideas portal. Whether it’s a feature request or a usability improvement, your input directly shapes our roadmap.
Learn more about Migration Assistant and try it out today!
