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?
asked 5 months ago1 views
1 Answers
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.
answered 4 months ago
Relevant questions
General questions regarding RDS SQL Server Read Replicas
Accepted Answerasked 2 years ago"Create Aurora Read Replica" option not available to migrate from RDS Postgres 11.12 to Aurora 11.12.
asked 2 months agoAurora Postgres 13 with IAM Auth - Unable to establish logical replication connection
asked 5 months agoUsing DMS to replicate single-tenant to multi-tenant DB structure.
asked 5 months agoDMS - When to switch the application to the new target database
Accepted Answerasked 3 months agoRDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
Accepted Answerasked 4 months agoHow to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?
asked 3 days agoS3 Integration Oracle RDS and DMS
Accepted Answerasked 2 years agoGranular per-instance access in an Aurora DB cluster
asked a month agoWriter Instance Scaling
asked 3 years ago