1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
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.
respondido há um ano
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 7 meses
- AWS OFICIALAtualizada há 2 anos
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