1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
as mentioned in limitations https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Limitations If your database isn't configured for MS-REPLICATION or MS-CDC, you can still capture tables that do not have a Primary Key, but only INSERT/DELETE DML events are captured. UPDATE and TRUNCATE TABLE events are ignored.
Thus to make sure everything is captured we need to enable ms-cdc for all tables in question.
답변함 한 달 전
관련 콘텐츠
- AWS 공식업데이트됨 2년 전