For DMS CDC Task MS-CDC Enabled for Single Table but worked for all Tables in RDS SQL SERVER

Question

Hi All,
           I'm working with DMS for Migrating Data between RDS SQL Server to RDS SQL Server. I just enabled MS-CDC at Database level and only for a Single Table. But in DMS CDC Task  I have selected all the tables and Migration worked for all the tables in the Database. 
       But in Official Documentation it says "MS-CDC must be enabled at the database level, and for all of the tables individually". So, did I missed anything or is this usual? How it is working for all the tables?

I've seen the below document for setting up the source RDS SQL SERVER https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Prerequisites

Thanks in advance.

Answer

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.

For DMS CDC Task MS-CDC Enabled for Single Table but worked for all Tables in RDS SQL SERVER

相關內容