1

I able to migrate from on-prem database to AWS using DMS service but couldn't able to migrate database from Azure to AWS.

Is there any better approach?

udayr
  • 31
  • 2
  • Possible duplicate of [Copying PostgreSQL database to another server](https://stackoverflow.com/questions/1237725/copying-postgresql-database-to-another-server) – Tim Biegeleisen May 29 '19 at 04:43
  • Why wouldn't at least some of the standard migration techniques still work in an cloud environment? – Tim Biegeleisen May 29 '19 at 04:44

1 Answers1

0

A pretty low level but effective way would be to: export your Azure data as CSV using pg_dump, copy it into an AWS S3 bucket (pretty easy with Python awscli package) and load from S3 into RDS Postgres.

Would be great if files could be moved directly from blob storage to s3, but I don't think Azure Postgres supports dumping directly to blob anyway.

systemjack
  • 2,815
  • 17
  • 26