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?