1 Answer
- Newest
- Most votes
- Most comments
1
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.
Relevant content
- asked 18 days ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated a year ago