1 Answer
- Newest
- Most votes
- Most comments
1
for CDC DMS relies on DDL/DML transactions captured in source database transaction log. This changes are populated when we enable ms-cdc. As the source db is getting restored the chain of transactions tracked by lsn (from active transaction log) is lost. Thus you need to restart the DMS task so that initial load is reinitiated.
answered a year ago
Relevant content
- Accepted Answerasked 10 months ago
- Accepted Answerasked a year ago
- asked 2 years ago
- AWS OFFICIALUpdated 5 months ago
- Why is no data migrated from my Amazon S3 source endpoint even though my AWS DMS task is successful?AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 6 months ago
Thank you for the quick and thorough reply. Do you happen to know what happens to the files in the S3's dbo and cdc folders, do they get deleted and recreated as replication builds up, or overwritten?
it is based on task setting if it is set to do_nothing they will be retained and new files will be added. while if you use truncate or "drop and recreate" they will be cleared