Migrate data from one DB to another DB

0

Hi Team,

I need advise on migrating data from one AWS DB running PostgreSQL in AWS to another DB running PostgreSQL also in AWS.

There are thousand's of tables within the DB that is to be migrated from source to destination and I was exploring Glue ETL but cannot find any reference material that can be leveraged. I do not need to continuously migrate data so I do not believe DMS service would be of help here.

There are other databases also where similar tasks is to be performed which have smaller number of tables and is running MySQL database and source / destination DB is within the same RDS instance.

Can someone advise on best way to migrate data from

  • Source DB to Destination DB within same RDS instance?
  • Source DB to Destination DB to a different RDS instance within same AWS account?
  • Source DB to Destination DB to a different RDS instance within different AWS account?
2 Answers
0

Have you tried looking into DMS (Database Migration Service)?

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html

profile picture
EXPERT
answered 8 months ago
profile picture
EXPERT
reviewed 8 months ago
profile pictureAWS
EXPERT
reviewed 8 months ago
  • I did, but I cannot find a way to select particular database (all tables within it) as the source and specific database as the destination when both databases are in same RDS instance.

0

As my friend said, use DMS or just use pgdump manually.

profile picture
EXPERT
answered 8 months 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