1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
répondu il y a un an
Contenus pertinents
- demandé il y a 6 mois
- demandé il y a un an
- demandé il y a 6 mois
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 6 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
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