By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

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

0

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?

Topics
Migration & ModernizationDatabase
Tags
Migration & ModernizationAWS Database Migration ServicePostgreSQL
Language
English
Radwan
asked 3 years ago501 views
1 Answer
0

The Schema Conversion Tool is where you should start. There are options to use Glue to perform ETL as well. This may be your solution.

profile pictureAWS
Rodney Lester
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content