Attention data engineers, database developers, and data analysts! We're pumped to reveal exciting upgrades to Mirroring for Azure SQL Database in Fabric today at the Fabric Conference in Las Vegas 2025. Since it became Generally Available, Mirroring for Azure SQL Database has been a game-changer, letting you replicate data seamlessly and integrate it within the Fabric environment. We're talking near real-time data accessibility and some serious analytics power!
What's New?
We've been hard at work, taking your feedback into account, and developing some epic new features to make your life easier:
- Support for SQL Databases behind firewalls: In public preview now! Secure data replication for databases behind a firewall, boosting your data security and compliance. Learn more here
- Mirror tables without Primary Keys: You asked to relax this limitation, we listened! This feature lets you mirror tables even if they don't have a primary key sometimes referred to as heap tables. More flexibility for your data replication needs.
- Setup mirror with reduced SQL permissions: Another ask from you to simplify your setup process keeping in mind principles of least privileges. This enhancement allows mirroring with reduced SQL permissions, making it more secured and less complex. Learn more here
What's Next?
We've got some awesome plans to further enhance Mirroring for Azure SQL in Fabric:
- Support for Additional Data Types: We're testing this now. Soon, you'll be able to work with sql_variant, geography, geometry etc. data types, giving you more options to mirror within Fabric OneLake
- User Assigned Managed Identity for Security: Currently in private preview, this feature lets you use User-Assigned Managed Identities (UAMI) in your mirroring setups, tightening security and simplifying management
- Mirror Vector Data to OneLake: We've already introduced the support of Vector data type in Azure SQL Database. Soo, we’ll be introducing the ability to mirror vector data directly to OneLake, ramping up your AI focused data processing and analytics capabilities.
- Cross-Tenant Mirroring: Seamless data replication across two different Fabric tenants. Perfect for expanding as well as controlling the scope of data sharing and integration.
Resources
Tutorial: Mirroring Azure SQL Database in Fabric
Mirroring in Fabric - What's new
General availability (GA) of Mirroring for Azure SQL Database in Fabric
Submit your feedback on Fabric Ideas and join the conversation on the Fabric Community. To get into the technical details, head over to the Fabric documentation.
