DMS Create Migration Project gets stuck
Hello everybody, I'm following the documentation to convert a database schema (here), but I'm stuck in the "Create Migration Project" step.
Form Descriptions
The first thing I've noticed in the creation form is the descriptions of "Source" and "Target":
Source and Target
When I set the source data provider, everything seems ok:
But when I try to set the PostgreSQL target:
The only available choice is the same as the source. I tried to select PostgreSQL as Source, but I can only use PostgreSQL in the Target section.
Thanks in advance for any help!
- Newest
- Most votes
- Most comments
Hi
DMS schema conversion does not support MySQL to Postgres conversion or vice versa. It's only supported for homogeneous conversion.
Source for DMS schema conversion -> https://docs.aws.amazon.com//dms/latest/userguide/CHAP_Introduction.Sources.html#CHAP_Introduction.Sources.SchemaConversion Targets for DMS schema conversion -> https://docs.aws.amazon.com//dms/latest/userguide/CHAP_Introduction.Targets.html#CHAP_Introduction.Targets.SchemaConversion
If your goal is to migrate data from a MySQL database to a Postgres database or vice versa. I would recommend simply looking at creating a DMS task and forgoing the schema conversion (https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.Creating.html). Schema conversion is required only if you have specific conversion needs.
If you look at the first screenshot, the description of the Source and Target fields are identical. Is it correct?
As mentioned in another answer, DMS Schema Conversion is limited in source and destination. However you can use AWS Schema Conversion Tool that is a stand-alone package with more flexibility in terms of heterogeneous conversions and covers your source and destination.
Relevant content
- asked 2 years ago
- asked 9 months ago
- asked 6 months ago
AWS OFFICIALUpdated 7 months ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 7 months ago
Thanks for the quick response. Could you confirm for me if the form descriptions are correct?
Hi, sorry I didn't get what you mean by form descriptions