Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I would like to mirror a SQl database to Fabric but it has CDC enabled. This was implemented before Function Trigger bindings became available and we use it in a similar way - polling it and then calling a Function App to raise event messages on a Service Bus Topic.
So how can I workaround the mirroring constraint of CDC not being enabled? As I understand it the constraint is there because mirroring needs to manage it instead. Is there a way I can use the CDC that mirroring enables?
Given this constraint, it is also apparant that Function App Trigger binding also can't be used with mirroring - which seems quite restrictive to me.
Solved! Go to Solution.
Hi @JasonSteele
Mirroring and SQL's CDC capability cannot co-exist. However, function triggers and Change Tracking capabilities should work fine with Mirroring. Have you tried creating an mirroring sql database with change tracking and azure sql trigger for functions?
This is the link for the tutorial: Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsof...
Hope this helps. Please let me know if you have any further questions.
Hi @JasonSteele
Thanks for using Fabric Community.
Currently there is no work around for this issue. This is a limitation.
Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
Hope this helps. Please let me know if you have any further queries.
Hi @JasonSteele
Mirroring and SQL's CDC capability cannot co-exist. However, function triggers and Change Tracking capabilities should work fine with Mirroring. Have you tried creating an mirroring sql database with change tracking and azure sql trigger for functions?
This is the link for the tutorial: Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsof...
Hope this helps. Please let me know if you have any further questions.
Many thanks for this, we will certainly explore this.
Hi @JasonSteele
Glad that I could help you. Please continue using Fabric Community for any help regarding your queries.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |