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

[simontidd]

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.

[dlevy · Accepted solution]

Hi @simontidd - it's supported. You do have to use Entra authentication though. Here's the docs page with everything you need: https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql

[Anonymous]

Hi @simontidd 

Now , it cannot put the SQL Server directly to the Fabric,  This feature is not supported at this time, if you want to put it to Fabri Database, you need to create a new database in Fabric and copy the related sql query to create the related table. you can refer to the following link about it.

SQL database tutorial - Create a SQL database in Fabric Database - Microsoft Fabric | Microsoft Lear...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.