Share via

Migrating from AWS RDS Postgresql to Azure for Postgres flexible server - Big table sizes

LuisC 0 Reputation points
2024-07-17T20:56:57.6766667+00:00

The issue I have is that our tables have big sizes, for example, 500Gb, and I saw in here that we have a limit of 1TB. My issue would be solved if I could use 2 DMS instances pointing to the same database but different tables, is that even possible?

Azure Database Migration service
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. akinbade abiola 8,450 Reputation points
    2024-07-17T22:43:43.2266667+00:00

    Using multiple DMS instances for different tables in the same database is not supported.

    You can attempt a phased migration by migrating first the smaller tables and then implement horizontal partitioning for your large tables

    You can mark it 'Accept Answer' and 'Upvote' if this helped you

    Regards,

    Abiola

  2. Oury Ba-MSFT 17,791 Reputation points Microsoft Employee
    2024-07-18T18:51:29.6833333+00:00

    @LuisC Thank you for reaching out.

    In addition to the above answer provided by akinbade abiola.

    The above link you are looking at is our old data migration service which is replaced by our new service Migration service in Azure Database for PostgreSQL - Azure Database for PostgreSQL - Flexible Server | Microsoft Learn.

     We have updated the documentation, but some areas are currently being updated including the routing from old to new service. Our new service not only have “No Size Limitations” but it also parallelizes large table into multiple batches to speed up the performance. It is executed directly from the Flexible Server.

    Regards,

    Oury