AWS DMS RDS PostgreSQL to MYSQL

0

I am trying to use AWS DMS to migrate our PostgreSQL to MySQL which are hosted in AWS RDS. PostgreSQL version = 14.0 MySQL version = 8.0 Below are the steps I followed:

  • created a replication instance
  • created a instance profile.
  • created two data providers one for PostgreSQL and other for MySQL.
  • Then I created migration task. Now this is where the issue came up. I selected source data provider as PostgreSQL but then I can't find MySQL in the supported target data provider. Even doing the reverse is not working. creating migration task as you can see above, the target provider is same as source

Data providers data providers I created as you can see above, there are 3 mysql engine and 1 postgresql

Endpoints Enter image description here

Since my source and target DB engine are mentioned in the list of supported DB in AWS doc, can it be possible that a certain combination of heterogeneous migration is not possible? AWS have not mentioned what combination of source and target are supported.

1개 답변
0

Hi,

You do not mention the creation of source and target endpoints: they are mandatory for DMS to work. See https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.HighLevelView.html

So, did you create them?

Detailled guidance to create them: https://repost.aws/knowledge-center/create-source-target-endpoints-aws-dms

Best,

Didier

profile pictureAWS
전문가
답변함 8달 전
  • yes those are created by manually providing access information

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

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

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

관련 콘텐츠