SQL Meets Fabric: Migrate and version-control your SQL workloads
2025TL; DR
Migrating SQL databases to Microsoft Fabric can seem daunting, especially when organizations have invested years into finely tuned schemas, stored procedures, and workflows. However, the process doesn’t need to be a reinvention. By leveraging well-established SQL tools such as Database Projects, DACPACs, BACPACs or brand new features like mirrored databases, you can seamlessly migrate your databases into Fabric while maintaining data integrity and compatibility with new features.
Session Details
Migrating SQL databases to Microsoft Fabric can seem daunting, especially when organizations have invested years into finely tuned schemas, stored procedures, and workflows. However, the process doesn’t need to be a reinvention. By leveraging well-established SQL techniques such as Database Projects (DACPACs), backup files (BACPACs) or brand new features like Mirrored databases, you can seamlessly migrate your databases into Fabric while maintaining data integrity and compatibility with new features.
This session explores practical techniques to migrate SQL databases to Fabric using these tools, enabling you to make the most of Fabric’s ecosystem without discarding your existing SQL investments.
💡 What You'll Learn:
1. How Database Projects to version-control schemas works in Fabric.
2. The difference between DACPACs and BACPACs, and when to use each.
3. Step-by-step demonstration of migrating schema and data into Fabric SQL Databases, using Azure DevOps pipelines to automate deployment workflows.
4. Using Mirrored Azure Databases in Fabric as alternative to migration
By leveraging tools like Azure Data Studio, Database Projects and Deployment pipelines, migrating to Fabric SQL Databases becomes a smooth, predictable process. These techniques allow you to preserve years of SQL investments while unlocking the power of Fabric’s integrated data and AI services.
Whether you're modernizing legacy databases or adopting Fabric for the first time, these approaches provide a clear path forward.
This session explores practical techniques to migrate SQL databases to Fabric using these tools, enabling you to make the most of Fabric’s ecosystem without discarding your existing SQL investments.
💡 What You'll Learn:
1. How Database Projects to version-control schemas works in Fabric.
2. The difference between DACPACs and BACPACs, and when to use each.
3. Step-by-step demonstration of migrating schema and data into Fabric SQL Databases, using Azure DevOps pipelines to automate deployment workflows.
4. Using Mirrored Azure Databases in Fabric as alternative to migration
By leveraging tools like Azure Data Studio, Database Projects and Deployment pipelines, migrating to Fabric SQL Databases becomes a smooth, predictable process. These techniques allow you to preserve years of SQL investments while unlocking the power of Fabric’s integrated data and AI services.
Whether you're modernizing legacy databases or adopting Fabric for the first time, these approaches provide a clear path forward.
3 things you'll get out of this session
Mastering SQL Migration Techniques in Fabric
Real-Time SQL Integration with Mirrored Databases
Automating SQL Migration with Azure DevOps