Using DMS to replicate single-tenant to multi-tenant DB structure.

Question

We have a PostgreSQL DB with single-tenant structure that include around 15k schemas. The data size is around 3 TB.
We want to replicate the data of those schemas into one big MySQL multi-tenant DB. 
Note: all schemas have the same tables' structure, and the same for the target DB.

Can DMS help us achieving that?

Answer

The [Schema Conversion Tool](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html) is where you should start. There are options to use [Glue to perform ETL](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP-converting-aws-glue-ui-process.html) as well. This may be your solution.

Using DMS to replicate single-tenant to multi-tenant DB structure.

Contenuto pertinente