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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ