AWS DMS: Data not getting replicated to AWS Redshift

Question

My source DB is AWS RDS and my target table is AWS Redshift. The data is loaded successfully but after that changes are not pushed to the target DB and there are no exceptions.

Configuration: Migration type: Full Load, Ongoing Replication Source DB: AWS RDS MariaDB Target DB: AWS Redshit

Issue: After first upload there are no inserts, updates, deletes to the target DB.

Update: I restarted the DMS task, it duplicated the database records on target DB but now it is updating the target DB. I drop and reloaded one table and it duplicated the record.

What is the best way of fixing this issue now? :( Drop and reload of table is not working for us. — JDev, Nov 17 '17 at 17:30
I think ShellCommandActivity can be used to the updates after first full load is done — Cyrus, Nov 17 '17 at 17:36
why don't you create two separate tasks, one for full load with "migrate existing data" and one for updating with "replicate data changes only"? — Cyrus, Nov 17 '17 at 17:41

score 0 · Answer 1 · answered Nov 18 '17 at 03:24

0

I guess the problem was, I updated the Redshift Database name and that somehow created problems with my AWS DMS tasks.

Creating a fresh task worked for me.

answered Nov 18 '17 at 03:24

JDev

1,662
4
25
55

AWS DMS: Data not getting replicated to AWS Redshift

1 Answers1