1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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.
con risposta un anno fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 7 mesi fa
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