Does CDC works with Always On SQL Server Replicas

[Navneet Mishra]

Hi,

Is there any way the CDC can be enabled on the secondary server and capture the changes done on the secondary without affecting the primary considering the AlwaysOn HADR configuration?

[Chris Cranford]

Yes, it can.  Please see the pre-requisites [1].

Thanks,
Chris

[1]: https://debezium.io/documentation/reference/2.4/connectors/sqlserver.html#sqlserver-always-on-replica

On 8/29/23 01:13, Navneet Mishra wrote:

Hi,

Is there any way the CDC can be enabled on the secondary server and capture the changes done on the secondary without affecting the primary considering the AlwaysOn HADR configuration?

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/CAKWC1fVLjMF0jn13SuX5RO3_tLUaBocN7_GKoP-FKAc4%2Bfz4SQ%40mail.gmail.com.