MongoDB to DynamoDB

Question

I have a database currently in Mongo running on an EC2 instance and would like to migrate the data to DynamoDB. Is this possible and what is the most cost effective way to achieve this?

Answer 1

When you ask for a "cost effective way" to migrate data, I assume you are looking for existing technologies that can ease your life. If so, you could do the following:

• Export your MongoDB data to a text file, say in tsv format, using mongoexport.
• Upload that file somewhere in S3.
• Import this data, in S3, to DynamoDB using AWS Data Pipeline.

Of course, you should design & finalize your DynamoDB table schema before doing all this.