What happens when a source endpoint database is restored that is part of a data migration task

0

Using AWS DMS there are source endpoints (On-Prem SQL Servers) and associated target endpoints (S3).

Could someone with experience tell me what happens when a source endpoint (sql-server) gets restored, and CDC is re-enabled on that database.

For the associated data migration task, I hope that DMS will see this a requiring a new snapshot/initial load (in transactional-replication parlance). If not, how does one contend with this. These restores can happen with databases from multiple servers and on a frequent basis.

Normally, I would test this out, however, our dev accounts are locked down with limited console access, everything has to be scripted in terraform and this would take some time to get a "quick test" up and running.

1개 답변
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.

AWS
답변함 일 년 전
  • 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

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠