I am trying to use AWS DMS to migrate our PostgreSQL to MySQL both of 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 not showing my mysql data provider
Data provider:
as you can see above, there are 3 mysql engine and 1 postgresql that I created
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.
