Azure SQL works as a production relational database while Fabric is a data intelligence platform. We need to ingest and transform the data from production to data intelligence.

This ingestion process need to happen without creating a heavy load to production, otherwise this would affect production applications.

Fabric provides 3 different features to allow us implement this: Mirroring, CDC Ingestion and Fabric Databases.

Each one of these features have different purposes and benefits. The decison between which one to use relies on the modeling features we want to implement, such as the SCD type we want to apply to our dimensions.

In this session we will talk about the differences between these features and the best scenarios to implement each one. We will also cover the data modeling practices which requires us to choose one of these features.