AWS Database Migration Service (DMS) helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases.
The Database Migration Service is a data mover. It creates only the structures required to migrate your data, (this is for performance reasons mainly.) Additionally, it doesn’t migrate secondary indexes, default values, procedures, triggers, auto increment columns etc. These objects/modifications need to be made after migrating the data, (and typically prior to switching the app.)
But it can be fixed by importing schema manually.
missing foreign keys and/or indexes
To fix foreign keys & indexes missing issue, follow this
- Import Database schema manually to RDS.
- Set “`Target table preparation mode“` to “`Truncate“`
Using DMS GUI:
Now run the task.
You will see all foreign keys and indexes in target (RDS).