Migrate data from one DB to another DB

Question

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?

Answer

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

Answer

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

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

Migrate data from one DB to another DB

Relevant content