Change Data Capture, CDC, from an on premise SQL Server to a Microsoft Fabric SQL Database? Here it is! Plus we show how to use the Mirror of the Fabric SQL Database to access your data in a Lakehouse or a Warehouse any way you want your data Bradley Ball, aka @SQLBalls , has got you covered! Part 1 Microsoft Fabric: Incremental Copy Job on Prem SQL to Fabric SQL DB or Warehouse Change data capture (CDC) in Copy Job (Preview) What is Copy job in Data Factory for Microsoft Fabric? /******************* /CONNECT WITH US!! /******************* Tales from the Field Blusky: Twitter/X: Linkedin: Bradley Ball Blusky: Twitter/X: Linkedin: Daniel Taylor Blusky: Twitter/X: Linkedin: Bradley Schacht Blusky: Twitter/X: LinkedIn: Neeraj Jhaveri Blusky: Twitter/X: Linkedin: Josh Luedeman Blusky: Twitter/X: Linkedin: Chapters 00:00 Limitations of Watermark Copy Jobs 01:47 Demo Environmental Review Microsoft Fabric & SQL Server 02:43 Demo Setting up Change Data Capture on the Database & Tables 03:45 Demo Create Copy Job using CDC 05:25 Demo Running the Copy Job 05:37 Demo Examine the Fabric SQL Database Mirror & Replication 06:10 Demo Create Shortcut from Mirror to Lakehouse 06:45 Demo Create three point naming convention view in Warehouse to Mirror 07:13 Demo Validate totals on SQL Server, Fabric SQL DB, Warehouse, Lakehouse, & Mirror 08:12 Demo Create Updates 08:36 Demo Run Copy Job 08:48 Demo View Mirror Replication 09:06 Demo Validate totals on SQL Server, Fabric SQL DB, Warehouse, Lakehouse, & Mirror 9:35 Demo Insert 50K rows and Update rows divisible by 2 9:50 Demo Run Copy Job 10:03 Demo Validate totals on SQL Server, Fabric SQL DB, Warehouse, Lakehouse, & Mirror 10:34 Demo Deleting Rows 10:45 Demo Run Copy Job 10:59 Demo Validate totals on SQL Server, Fabric SQL DB, Warehouse, Lakehouse, & Mirror #microsoftfabric #fabric #MSFTFabric #Warehouse #datawarehouse #CDC #ChangeDataCapture #pipeline #datapipelines #datafactory #sqlserver #ssms #lakehouse #shortcuts