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개 답변
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
전문가
답변함 10달 전
  • @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
전문가
답변함 10달 전
0
AWS
답변함 10달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠