SQL in Fabric | Can you use SQL Server replication direct to Fabric

I'm looking into getting on-prem SQL tables into Fabric. We're looking at mirroring but that currently seems to rely on a sort of workaround using replication to Azure SQL before mirroring: Mirroring SQL Server database to Fabric | Microsoft Fabric Blog | Microsoft Fabric as Will posted here: Mirroring for on-prem SQL Server · Learn Microsoft Fabric.

Given there is now SQL directly in Fabric: Announcing SQL database in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric. Can you not set up replication for the on-prem SQL Server directly to SQL in Fabric? Has anyone tried it?

I currently am trying it but hitting a roadblock because our SQL Server is pre-2022 and doesn't support Entra Authentication. I'm wondering whether it is worth pushing the relevant team to upgrade but don't want to if it won't work anyway.

9 comments