I have used DMS for AURORA PostgreSQL to PostgreSQL SCHEMA Migration. Migrate Data only type is used for DMS activity.
After a Full load of Data, all tables were created on the target endpoint with all data along with it.
The problem is when we cross-checked with target DB, It hasn't had Foreign Keys, Sequences in target, and Some Indexes got renamed. Also, DDL doesnt have the default statements, and Defaults in tables are blank. Does DMS not take of these?