I have a production DB which I need to effectively mirror and in addition stream changes to applications for their own purposes. (using something like AWS DMS)

The catch is that the source database need to have the least performance/storage/config impact for this, hence why I'm looking to mirror the DB and have all the Change Data Capture (CDC) config on the target.

Having Transaction Replication setup introduces a problem where the initial snapshot wipes out all the CDC configuration which needs to be re-applied on a snapshot restore.

Are there any other alternative setups that might work for this use-case?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.