CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-dynamodb
developerCK
developerCK

Reputation: 4506

Data Migration from Dynamo Db to AWS RDS Mysql

I am using AWS dynamo db to store data. Now i want to export it into mysql.

i just want a way so that, so that i can export data from dynamo db to mysql on regular basis. Mysql will be work as backup db.

what will be the best approached!

Upvotes: 0

Views: 2849

Answers (2)

kartik
kartik

Reputation: 2135

Write code in java using scan functionality of Dynamo DB and export the data out into file, you can later use RDS specific SQL Load utility. You have to use lastkey feature of DynamoDB to continue scan for next call and continue the scan to avoid outofmemory error.

Upvotes: 1

yegor256
yegor256

Reputation: 105193

Take a look at my simple node.js script dynamo-archive, which exports to JSON format. Then you can parse it and import to MySQL.

Upvotes: 0

Related Questions