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.
as you can see above, the target provider is same as source
Data providers
as you can see above, there are 3 mysql engine and 1 postgresql
Endpoints
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.
yes those are created by manually providing access information