Any workaround for not being able to mirror a database that uses CDC?

[JasonSteele]

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.   

[Anonymous]

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.

[Anonymous · Accepted 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.

[JasonSteele]

Many thanks for this, we will certainly explore this.

[Anonymous]

Hi @JasonSteele 

Glad that I could help you. Please continue using Fabric Community for any help regarding your queries.