Loading
Topic
Real-Time Replication
1 post about Real-Time Replication by 1 contributor.
Know Real-Time Replication? Share what you know with developers who are learning it.
+ Follow Real-Time ReplicationBe the first to follow this
- Videos
- 1
- Contributors
- 1
Everything about Real-Time Replication
- Video · Microsoft Fabric
Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse
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.
