How can I migrate a multischema database with AWS DMS

You can migrate your multischema databases with AWS DMS. You only have to create a source endpoint and a destination endpoint. If you are using postgresql for example, it would be your origin and redshift your destination.

Then you have to create a migration task, here you can define that the same schemas in the source db are created in the destination and the tables are migrated, preserving the original structure.

Also with DMS transformations you can create a single schema in the destination and send all the tables per schema to the destination. Of course you should rename the name of each table so that there are no collisions, but you can differentiate them between the tables of the source schema.

• Migration task https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.Console.html