Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse
Sep 26 2024

Abiola David

In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabric Onelake.-- Connect to Azure SQL logical server using SQL Server Mgt Studio.-- Create Microsoft Entra ID authenticated login in the master database.-- Switch Database we want to Mirror in Fabric.-- Create database user to connect to the Entra ID login created above.-- Create and Insert records to SalesData table and ensure it contains primary key.-- Set up Mirroring in Fabric Warehouse workspace.-- Mirror the replicated Salesdata table in SQl Analytics Endpoint.-- Create insert new records to the SalesData from the SSMS, replicate again and query the table to see new records.-- Create product table, insert records and replicate to see the new table replicated for querying.-- Talk about the observed limitation.