By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Migrate Specific records from RDS to S3

0

Hi, I have a use case where have to periodically check and archive some years old data from RDS to S3. Also hard delete from RDS later. Can i leverage DMS here as i need to query data by timestamp after an interval or will need to write a custom lambda ?

Topics
StorageMigration & ModernizationServerlessComputeDatabase
Tags
ArchivingAWS Database Migration ServiceAWS LambdaDatabaseStorage
Language
English
rePost-User-2508749
asked a year ago418 views
2 Answers
0

Hi, DMS will allow you to export to S3 data that is updated by your application at the moment of this update. It seems that your use case is different.

Our ETL service Glut seems more appropriate to what you want to do: check it out at https://aws.amazon.com/glue/

profile pictureAWS
EXPERT
Didier_Durand
answered a year ago
0

i think your scenario fits as per the aws blog https://aws.amazon.com/blogs/database/archiving-data-from-relational-databases-to-amazon-glacier-via-aws-dms/

AWS
subhashr
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content