Reliable way for AWS Aurora PostgreSQL to Azure PostgreSQL migration

Rohit Agarwal 5 Reputation points
2023-09-28T04:38:57.9233333+00:00

Hello community members,

Looking for an approach for migrating live AWS Aurora PostgreSQL database in Azure. As Azure DMS doesn't support this as a source but given Aurora is built on top of PostgreSQL, what are possible ways considering need is to capture incremental data as well using proper change data capture for a proper cut-over of production:

  1. How much DMS would be able to support given it already has direct support for AWS PostgreSQL
  2. Native supporting tool(pgadmin and more) from PostgreSQL which can be used to export and import the backups incrementally in Azure
  3. Any other way with custom aggregation of tools

Although, tried to cover documentation available, please feel free to redirect to something particular.

Azure Database Migration service
Azure Database for PostgreSQL

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-10-03T08:57:29.27+00:00

    Hi Rohit Agarwal •,

    Thanks for your patience.

    We have got the below reply:

    • We have introduced the private preview of offline based migration service to migrate from IaaS/On-Premises to Azure Database for PostgreSQL – Flexible server using CLI mode. We have not tested it with AWS RDS or Aurora but behind the scenes it uses pgcopydb for migration. If you are interested and has NDA with Microsoft then can participate in the private preview - https://forms.office.com/r/s7Rm3jLdVH
      • Key Benefits –

    Homogenous PostgreSQL migration solution.

    Managed migration service.

    No complex setup/pre-requisites required.

    Simple to use portal-based/CLI migration experience.

    Fast offline migration service.

    No limitations in terms of size of databases it can handle.

    Automatically, spin up a purpose-built docker container in the target Azure Database for PostgreSQL - Flexible server and drive the incoming migrations.

    Support for Schema and Data migrations.

    • Using native pg_dump and pg_restore or using native logical replication. Users can take the pg_dump from AWS aurora and restore in Azure Database for PostgreSQL – Flexible server.
    • 3<sup>rd</sup> party products like Striim.

    Let us know if this helped.

    If not, do let us know the details to assist you.

    Thanks

  2. Vishwesh 0 Reputation points
    2023-12-13T05:22:40.53+00:00

    Hi Rohit / Shakti Singh - I thought Azure DMS supports AWS RDS as source however I have been told it supports Aurora as well. Have you been able to identify any alternatives for online migration?

    0 comments