Azure SQL DB Data Portability : Mirroring, CDC, Export/Import and DataSync
summary
Quick practical rundown: Import/Export is fragile above 200 GB limit so use SQLPackage (wraps DACFx) instead — SQLPackage is in public preview for larger exports/imports and supports SQL MI and SQL Server 2022 today. Data Sync uses a Hub/Spoke sync group, per-subscription metadata DB, 5s frequencies and column/table filters but not selective DML direction. CDC creates capture tables (default cleanup 3 days); Change Tracking is metadata-only. Fabric mirroring reads the transaction log, writes Delta Parquet into OneLake for near‑real‑time analytics, currently private preview with ~15–30% overhead and limited to regular tables with PKs.
AI-written summary · about
chapters (7)
- 0:00Introduction to portability
- 4:05Import and export tools
- 13:58Data sync for hybrid setups
- 21:16Change data capture (CDC)
- 24:44Change tracking vs CDC
- 29:23Mirroring in Microsoft Fabric
- 38:59Summary and Q&A session
related talks
48mAccelerate insights with real-time Azure SQL data and Microsoft Fabric
26mData Replication Options for Azure SQL PaaS Services
15mNear real-time analytics on Azure Cosmos DB with Microsoft Fabric mirroring
49mAnalytics in SQL Server and Azure SQL Database
31mData Replication in Azure SQL and Beyond
50mAzure SQL Managed Instance Roadmap
55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?
50mMicrosoft Fabric Data Factory Q&A