Mirroring Database from MS SQL Server

[Muhamad_Rifqi]

Hi, is it possible to perform mirroring database from MS SQL Server ( On prem ) to Ms Fabric ?

[v-karpurapud]

Hi @Muhamad_Rifqi 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-karpurapud]

Hi @Muhamad_Rifqi 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-karpurapud]

Hi @Muhamad_Rifqi 
Hope you are doing well!

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud]

Hi @Muhamad_Rifqi 

Thanks for reaching out to Microsoft Fabric Community Forum.

We have reviewed the response provided by @nilendraFabric  and @NandanHegde  found it to be accurate and helpful.

In addition to that, we would like to provide some reference links which may be useful for you:
Mirroring SQL Server database to Fabric | Microsoft Fabric Blog | Microsoft Fabric
Tutorial: Configure Transactional Replication - SQL Server | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank You.

[nilendraFabric]

Hi @Muhamad_Rifqi 

It is not possible to directly mirror an on-premises Microsoft SQL Server database to Microsoft Fabric. The current mirroring capabilities in Fabric are limited to specific cloud-based data sources.

Microsoft Fabric currently supports mirroring from the following database sources:
• Azure SQL Database
• Azure Cosmos DB
• Snowflake

While direct mirroring is not available, there are alternative approaches to replicate data from an on-premises SQL Server to Microsoft Fabric:
1. Azure SQL Database as Intermediary:
• Set up transactional replication from on-premises SQL Server to Azure SQL Database.
• Then use Fabric’s mirroring capability to mirror the Azure SQL Database to Fabric.

Data Pipeline Approach:
• Create a data pipeline in Fabric to extract data from the on-premises SQL Server.
• Use the copy activity to transfer data to Fabric, potentially using incremental load patterns.
3. Striim’s SQL2Fabric-Mirroring Service:
• A third-party solution designed specifically for replicating on-premises SQL Server data to Microsoft Fabric.
• Utilizes Fabric Open Mirroring for real-time data replication.

If this is helpful please accept the solution and give kudos.

Thanks

Nilendra

[NandanHegde · Accepted solution]

Plz refer the below link:

https://www.youtube.com/watch?v=Gg3YlGyy5P8