different database schemas Service for Migrating Databases on AWS

[shannu970]

I have two databases: a source database and a target database. DBs have fully distinct schema and table structures. Using AWS DMS, I want to migrate all data from the source to the destination DB. Is it possible to map various columns from the source DB tables to various columns in the destination DB tables?

If you want further information, I can give it.

I'm looking for a fix or a workaround for using AWS DMS.

 

[James_Watson]

Fully distinct schema and table structures? And map various columns from the source DB tables to various columns in the destination DB tables?
Is it impossible that the destination DB tables have the same table schema as the source DB tables?