I have a table running on AWS RDS. I want to use AWS DMS to export all the data on the table every week. Each week after the export I will truncate the table so every next phase the source table will have new data and I planned to perform the DMS task to safely offload the data from the RDS table.
I have configured an RDS source and S3 bucket as target to export data as CSV. The replication type is Full-Load only and it migrates existing data(No Ongoing replication).
But the problem I found is that DMS keeps dropping the old LOADXXXXXXX.csv file from the target s3 whenever I perform the reload-target operation on the DMS task next week.
How can I achieve my goal? How to configure AWS DMS to keep multiple full load files in the same s3 target destination?
