Migrate RDS MySQL to EC2 MongoDB using DMS Service.

0

Hi Team,

Is possible to migrate directly from RDS MySQL to EC2 Mongo DB using DMS Service? If yes How to do that? Because there is no target endpoint for mongo DB.

3 Answers
0

The following documentation shows no MongoDB as a target.
Migration to Amazon DocumentDB may be possible.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Targets.html

Amazon DocumentDB (with MongoDB compatibility)

profile picture
EXPERT
answered 10 months ago
  • @Riku_Kobayashi Is there any other way to do this?

  • What i am planning First export all the data from MySQL data as CSV file and store to S3 from there to import to EC2 MongoDB using mongoimport.

    Here one problem i am facing after exporting all the data to CSV file dosen't have column headers all the data are migrated without headers. How to add the column headers in that CSV file is this possible?

  • Set "AddColumnName" to true in the endpoint configuration. Setting this to true will add a header to the CSV file. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html#CHAP_Target.S3.Configuring
    s3

0

According to this: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.AWS.html

You can use AWS DMS with several other AWS services: You can use an Amazon EC2 instance or Amazon RDS DB instance as a target for a data migration

Thought above is true, I could not find though a step to step guide, but should be possible if target can be an EC2 endpoint.

profile picture
EXPERT
answered 10 months ago
0
AWS
answered 10 months 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