Skip to content
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
AWS Database Migration ServiceMigration & ModernizationPostgreSQL
Language
English
asked 4 years ago555 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.

AWS
answered 4 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.

Relevant content