0

I have been trying to migrate the data from my source endpoint which is an Amazon RDS DB instance to my target endpoint which is Amazon Redshift.

I am step-by-step following everything mentioned in the docs and my table is getting migrated successfully but unfortunately the data present in the table is not being reflected in the Amazon Redshift instance.

The table migration is successful, but when I click on the table statistics option, then the number of inserts is 0. That means although the table and schema were migrated but not the data.

Table Statistics

Have you faced this situation? If yes, what are the ways to fix this?

Syed Kamran Ahmed
  • 27
  • 5
  • please add some detail. What are the stats for that table showing in DMS? what is missing exactly? – Jon Scott Apr 30 '21 at 11:17
  • The table migration is successful, but when I click on the table statistics option, then the number of inserts is 0. That means although the table and schema were migrated but not the data. – Syed Kamran Ahmed Apr 30 '21 at 11:22
  • check the table to make sure there are rows. check using the same credentials as being used by dms. check the migrations options to ensure that they are not filtering rows. check the migration type to ensure that it is "migrate existing data". check the target table preparation mode. check the logs (you did click to enable cloudwatch logs right?). ideally post the whole thing in json format into your question. – Jon Scott Apr 30 '21 at 13:15

0 Answers0