Use of CDC for Database Migration Service with SQL Server RDS source

0

Hi - I'm trying to get my head around DMS, and how on-going replication works with a MSSQL RDS source.

As I understand it, on-going replication uses the fn_dblog function to read from the transaction log, so DMS can sync changes to the target. It opens a transaction against the awsdms_truncation_safeguard table to stop the transaction log being prematurely truncated.

Why then is it necessary to enable CDC on the SQL Server? Unless I've missed something obvious, DMS is not consuming the change tables which SQL Server maintains when CDC is enabled? Why is the CDC pollingInterval important for DMS? I ask because I have DMS running against a highly transactional table, and I'm having to manipulate pollingInterval, maxtrans, and maxscans to stop my transaction log filling up, and my lack of understanding of the process may be leading me to set them incorrectly. As I said, I don't even see why CDC is necessary....

답변 없음

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

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

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