table not replicating in DMS from MySQL RDS to Redshift RDS

Question

Hi,  
  
I am using Amazon DMS to replicate my table from MySQL RDS to Redshift. I have created multiple task to replicate the tables from MySQL to Redshift. All the task are working fine and replicating the data except for one table. I deleted and recreated the task for that table but again its not replicating. I enabled the log for the same. the logs just show this message "ROTATE_EVENT (mysql_endpoint_capture.c:3132)". Please can someone help. I am in a fix as to what to do.  
  
Thanks in advance..  
Regards  
Parvez  
  
Edited by: Parvez on Mar 19, 2019 2:22 AM  
  
Edited by: Parvez on Mar 19, 2019 2:22 AM

Answer

I found the solution in the below post. Was not having primary key in my table.  
  
https://forums.aws.amazon.com/thread.jspa?threadID=232498

table not replicating in DMS from MySQL RDS to Redshift RDS

相关内容