about cdc migration

Question

hlw ,
 actually i am tring to mingrate cdc data but found the erroe , please help me as soon as possible

"Last Error Fatal error has occurred Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2880] [1022505] Failed (retcode -1) to execute statement; RetCode: SQL_ERROR SqlState: 42000 NativeError: 20028 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The Distributor has not been installed correctly. Could not enable database for publishing. Line: 1 Column: -1; Failed while preparing stream component 'st_0_NXRYOCRQYP462UX5EWX5NRDDUDPXLYCNC7TV5JI'.; Cannot initialize subtask; Stream component 'st_0_NXRYOCRQYP462UX5EWX5NRDDUDPXLYCNC7TV5JI' terminated [reptask/replicationtask.c:2888] [1022505] Stop Reason FATAL_ERROR Error Level FATAL"
Source endpoint: 
Target endpoint: 
Migration task (ARN): 
Timestamp:

Answer

Hi

From the error shared, this seems to be a situation that required steps not met.

Depends on what is the source SQL Server (RDS SQL Server or on-prem SQL Server)

For RDS SQL Server: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Configuration

For on-prem:
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.CDC

Also make sure the user used here for on-prem server (sysadmin or non-sysadmin) as there are two sets of steps mentioned in the public doc.

about cdc migration

Relevant questions

s3 source to postgresql - full load works but cdc doesn't

Using DMS CDC for Oracle to Postgres

About dms task fail

[bug report] Sagemaker data wrangler: An error occurred loading this view