Announcing the general availability (GA) of Mirroring for Azure SQL Database in Microsoft Fabric
We are thrilled to announce the General Availability of Mirroring for Azure SQL Database in Fabric. This milestone marks a significant step forward in our mission to provide seamless, near-real time data replication and integration capabilities for our users.
What is Mirroring in Fabric?
Mirroring in Fabric is a powerful feature that allows you to replicate your Azure SQL Database to Fabric’s OneLake. This ensures that your data is always up-to-date and readily available for advanced analytics, AI, and data science without the need for complex ETL processes. Setting up mirroring is simple, watch the video below.
Mirroring Demo: Setup, monitor, and seamless schema changes in Fabric
Key GA Features
Below are some of the key features as part of the general availability release:
Seamless Data Definition Language (DDL) support: Alter/Drop/Rename tables/column and yes, now you can Truncate tables in the source databases while mirroring is active. Learn more here
Programmatic Mirroring APIs: Easily set up and manage mirroring through APIs, providing greater flexibility and automation. Learn more Fabric mirroring public REST API
Support source Schema hierarchy: Source schema hierarchy is now fully supported in the Data Warehouse object explorer experiences.
Firewall Connectivity: This capability is currently in private preview to mirror an Azure SQL Database behind a firewall using either On-Premises Data Gateway. Click here to signup
We are also excited to announce the public preview of Mirroring Azure SQL Managed Instance as well as announcement of Open Mirroring.
What customers are saying
Since our public preview announcement, we’ve heard from many customers analyzing their data with Mirroring Azure SQL data, finding new insights and providing feedback. Below are a few:
“ETL used to consume up to 60% of a typical BI implementation, but with Fabric Mirroring, we now have an ‘easy button’ that lets us spend less time moving data and more time focusing on what truly matters—generating insights that drive real business outcomes” –Andre Fomin, CEO, Obvience
“Mirroring is a central part of the Enterprise Fabric in AP Pension. With minimal set-up and maintenance, it efficiently lets us off-load data from the source systems and ensure timely and accurate data availability for analysis and decision-making” – Jacob Jensen, Head of Platform, AP Pension
“By streamlining transfer of data from Azure SQL DB to Fabric, Mirror SQL Database not only saves us time and money, but also allows us to conveniently support near real time analytics.” – Dhyan, Senior Product Manager @ Ramsoft
Accelerate data potential with your Mirrored Azure SQL data in OneLake
Once your Azure SQL data is mirrored, any Mirrored database can be queried and cross joined with other Mirrored databases, warehouses, or lakehouses in Fabric. As every analytics workload in Fabric works seamlessly with OneLake, your Azure SQL data in OneLake can be used with Notebooks to analyze and create models, while building Power BI reports leveraging Direct Lake mode and semantic models quickly and efficiently
Mirroring Pricing
Mirroring for Azure SQL Database, same for all Mirrored databases, offers you with free compute and free storage based on the capacity size. For example, if you purchase an F64 capacity, you get 64 free terabytes worth of storage exclusively for mirroring. OneLake storage is charged only when the free Mirroring storage limit is exceeded.. You can learn more about Mirroring and OneLake storage pricing Microsoft Fabric – Pricing.
Summary
Today, customers Mirror their Azure SQL Database data into OneLake and accelerate their data potential with all workloads in Fabric. Together with Mirroring for Snowflake, Azure Cosmos DB, Azure SQL Managed Instance and many more sources to be added, you can leverage the same Mirroring technology and trivial setup to bring your data estate into OneLake.
We also love to learn about your ideas and what you need to run Mirroring in your production workload. Please add your ideas Fabric Ideas.
With Mirroring we’ve heard the following key benefits from our customers and partners:
1) Reduced total cost of ownership
2) Zero costs, zero ETL and zero code
3) Faster time to operational data, information to derive insights
Finally, please stay tuned to our Mirroring roadmap for new data sources and feature updates.
Resources to Learn more
- Tutorial on getting started with Mirroring Azure SQLDB
- Blog: Public Preview Updates Mirroring for Azure SQL Database
- Blog: Mirroring for Azure SQL Managed Instance
- Blog: Open Mirroring Announcement
- Mirroring for Cosmos DB in Fabric
- Get Started with a Fabric free trial
