Migration Assistant for Fabric Data Warehouse (Generally Available)
Migration Assistant for Fabric Data Warehouse is a powerful tool designed to streamline your journey to a modern, high-performance data platform. With this release, we’re making it easier than ever for organizations to migrate to Fabric Data Warehouse from any T-SQL database used for analytical work, such as Azure Synapse Analytics dedicated SQL pool, ensuring speed, reliability, and scalability for your mission-critical analytics.
The Migration experience allows users to easily migrate both metadata and data from the source database, automatically converting the source schema to Fabric Data Warehouse, helping with data migration, and re-routing connections.
- SQL surface: The Migration Assistant is designed to keep pace with the evolving T-SQL surface area, ensuring compatibility with a wide range of SQL constructs used in Fabric DW. As new capabilities are introduced in Fabric Data Warehouse, the tool is continuously updated to recognize and translate complex T-SQL patterns, making migration smoother and more reliable.
- Guided Migration Experience: The assistant simplifies the journey to Microsoft Fabric with an intuitive interface that helps you quickly identify the right target for your source environment. Step-by-step instructions walk you through uploading your DACPAC file and selecting the destination workspace and warehouse. Throughout the process, the assistant provides real-time updates and visibility into each stage of migration, keeping you informed.
- Migration summary: The Migration summary offers a clear and actionable snapshot of your migration results —showing what migrated successfully and what needs attention. With hover insights, you can explore object types and dependencies, while the full-screen view makes large migrations easier to navigate. The Fix Problems panel helps you quickly identify and filter issues, use Copilot to get resolutions and keeping your migration on track.
Why Migrate to Fabric Data Warehouse?
Migrating to Fabric Data Warehouse provides organizations with a cloud-native, distributed analytics engine designed for high-performance, enterprise-scale workloads. Leveraging the Migration Assistant, teams can transition existing data warehouse assets with minimal disruption while unlocking the several benefits:
- Lake-native architecture: Built on open Delta-Parquet format for seamless interoperability and ACID compliance.
- Unified analytics: Deep integration with Power BI and other Fabric experiences for real-time insights.
- No-knobs performance: Distributed query engine with autonomous workload management—no tuning required.
- Scalable and elastic compute: Instantly scale to meet business demands with separated storage and compute.
- Simplified ingestion and transformation: Use pipelines, dataflows, or T-SQL for flexible data movement.
- Cross-database querying: Analyze data across warehouses without duplication.
- Low admin overhead: SaaS experience with built-in governance, security, and monitoring.
To learn more, refer to the What is data warehousing in Microsoft Fabric? documentation.
How to Get Started
- Access the Migration Assistant: Open a Fabric workspace and select the Migrate button on the workspace toolbar. Select Analytical T-SQL warehouse or database card under Migrate to a warehouse category.
- Follow Step-by-Step Guidance: The assistant will walk you through, step-by-step instructions to migrate your source warehouse to Fabric warehouse.
Need help?
- Leverage Documentation and Support: Visit our documentation for Fabric deployment patterns and Migration guide to start your migration journey.
- Connect with your Microsoft account team: If you’re looking for personalized support, reach out to your Microsoft account team to get connected with the Migration Factory. Our experts are ready to help you assess, plan, and execute your migration with tailored guidance and tooling. And this support will not cost you anything, you heard it – it is FREE!
Share your ideas!
We encourage you to share your migration stories, challenges, and successes with the community. Your feedback continues to shape our roadmap, and we look forward to supporting your journey to a modern data warehouse. If there are features, you’d like to see, please submit your suggestions on the Ideas Portal.
Ready to experience the new Migration Assistant? Get started today and unlock the full potential of Microsoft Fabric Data Warehouse!
