SQLBits 2024

Azure SQL DB Data Portability : Mirroring, CDC, Export/Import and DataSync

Learn about data portability options for Azure SQL DB though Mirroring, CDC, Import/Export and DataSync.
"In the dynamic landscape of data management, ensuring seamless data portability is essential for both citizen developers and seasoned professionals.
This session explores a spectrum of techniques to integrate data into and out of Azure SQL Database, catering to diverse needs. Explore the modern approach of Mirroring, enabling continuous and effortless data ingestion into Microsoft Fabric - OneLake. Uncover the capabilities of Change Data Capture (CDC), a powerful tool for tracking and responding to data changes. Additionally, we'll shine a spotlight on the versatile strategies of Import/Export, facilitating smooth data movement for various scenarios. Explore the nuances of Data Sync, a useful feature for harmonizing data across databases.
Join us to gain insights into the evolving world of data portability, with a focus on strategies that empower you to manage data efficiently across a myriad of applications and environments."