topic Azure SQL Database Mirroring & CDC Limitation in SQL database

Azure SQL Database Mirroring & CDC Limitation

ELsea — Wed, 04 Jun 2025 14:51:17 GMT

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?

Re: Azure SQL Database Mirroring & CDC Limitation

mabdollahi — Thu, 05 Jun 2025 06:40:08 GMT

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

Re: Azure SQL Database Mirroring & CDC Limitation

Anonymous — Thu, 19 Jun 2025 05:33:46 GMT

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

Re: Azure SQL Database Mirroring & CDC Limitation

Anonymous — Mon, 23 Jun 2025 04:59:20 GMT

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

Re: Azure SQL Database Mirroring & CDC Limitation

ELsea — Mon, 23 Jun 2025 14:12:11 GMT

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