topic Re: SQL in Fabric | Can you use SQL Server replication direct to Fabric in SQL database

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

simontidd — Thu, 02 Jan 2025 12:51:29 GMT

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.

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

Anonymous — Fri, 03 Jan 2025 02:14:27 GMT

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 Learn

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.

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

dlevy — Fri, 03 Jan 2025 02:19:43 GMT

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