Azure SQL Database Mirroring & CDC Limitation

[ELsea]

What is the reason that Azure SQL DB cannot be mirrored if CDC is enabled? Will this restriction be lifted as Fabric continues to be developed? What's the best workaround for this?

[mabdollahi · Accepted solution]

Hi @ELsea 

Azure SQL Database doesn’t support mirroring to Microsoft Fabric when CDC is enabled. That’s because CDC relies on system tables and transaction logs that aren’t exposed through standard connectors or replicated to Fabric. This creates conflicts when trying to sync data pipelines or Real-Time Mirroring in Fabric.

It’s unlikely this restriction will change, since CDC is tightly coupled with internal SQL mechanisms. The better approach is to use incremental loading via ADF or Fabric Data Pipelines.

If this answers your questions, please feel free to mark it as correct solution to make it visible for next viewer.

Regards,

Mehrdad Abdollahi

[v-pgoloju]

Hi @ELsea.,

Thank you for reaching out to the Microsoft Fabric Forum Community. And also thanks to @mabdollahi for prompt and helpful response.

Just checking in to see if the information shared helped clarify your issue regarding Azure SQL Database mirroring with CDC enabled. Let me know if you need any further details or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @ELsea,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar

[ELsea]

Absolutely! Apologies for not accepting the solution sooner. Thanks to everyone for this great information.