Forum Discussion
Post ProdigyMirroring from a SQL Server on-premise
Hi,
in order to implement a mirroring from a SQL Server on-premise source in Fabric I'd like to know:
- is it necessary to enable the Change Data Capture feature for SQL Server?
- as a destination Fabric workload, is the mirrored database on OneLake enough or do I need to create a lakehouse/warehouse?
Thanks
Hi pmscorca
Thanks for reaching out community.
- is it necessary to enable the Change Data Capture feature for SQL Server?
Yes, you need to turn on the Change Data Capture in SQL server. CDC takes initial snapshot of selected tables and then keeps updating Fabric with any changes. Alos, you need compulsary to install On-premises data gateway to connect with your SQL server. Read more deatils here Microsoft Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn
- as a destination Fabric workload, is the mirrored database on OneLake enough or do I need to create a lakehouse/warehouse?
Since you are already mirriong the SQL server, the mirrored data automatically stored in Onelake of fabric.So when you use mirrioring in fabric, it automatically creates the follwing things in workspace.
- Mirriored database - this stores replcia of data in OneLake
- It automatically creats a read only SQL analytics end point for quering the data.
So, already you mirriored the SQL server, it is different from Lakehouse, it's not required to create a seperate lakehouse/warehouse until and unless if you have any additional strcted changes to your data. Read more details here Mirroring for SQL Server in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
2 Replies
- suparnababu8
Super User
Hi pmscorca
Thanks for reaching out community.
- is it necessary to enable the Change Data Capture feature for SQL Server?
Yes, you need to turn on the Change Data Capture in SQL server. CDC takes initial snapshot of selected tables and then keeps updating Fabric with any changes. Alos, you need compulsary to install On-premises data gateway to connect with your SQL server. Read more deatils here Microsoft Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn
- as a destination Fabric workload, is the mirrored database on OneLake enough or do I need to create a lakehouse/warehouse?
Since you are already mirriong the SQL server, the mirrored data automatically stored in Onelake of fabric.So when you use mirrioring in fabric, it automatically creates the follwing things in workspace.
- Mirriored database - this stores replcia of data in OneLake
- It automatically creats a read only SQL analytics end point for quering the data.
So, already you mirriored the SQL server, it is different from Lakehouse, it's not required to create a seperate lakehouse/warehouse until and unless if you have any additional strcted changes to your data. Read more details here Mirroring for SQL Server in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User! Hi pmscorca,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you are trying to implement mirroring from a SQL Server source. As pmscorca already responded to your query, kindly go through his response and check if it answers your query.
I would also take a moment to thank suparnababu8, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
