Implementing CDC process between a Microsoft SQL Azure Database and Google Cloud Platform

I’m trying to implement CDC between a Microsoft SQL Azure Database and Google Cloud Platform. Essentially, we host some of our software in Azure, but the main group’s data storage is in GCP.

My issue is that we use HADR geo-replication currently between our primary SQL Azure DB and a secondary SQL Azure DB. We don’t want to remove this, but it’s causing an issue. Part of the Documentation is asking to turn on Snapshot isolation. But this is impossible as the DB is involved in a mirroring session or availability group.

Is there anything I can do to force this, or can I reasonably go ahead with the CDC process without having the snapshot in place?

Read more here: Source link