How to Migrate Oracle to Azure database for postgresql(PAAS) using DMS

Velmurugan 1 Reputation point
2022-04-07T07:42:07.113+00:00

Hi Team,

I wanted to migrate Oracle to Azure database for PostgreSQL(PAAS) using DMS. Kindly provide us the steps/documents to follow the same.

@ GeethaThatipatri-MSFT As requested, I have created the new one. Kindly help on the same.

Azure SQL Database
Azure Database for PostgreSQL
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 19,276 Reputation points Microsoft Employee
    2022-04-07T19:30:17.943+00:00

    Hi, @Velmurugan Thanks for the ask and for using the Microsoft Q&A platform.
    As we understand the ask here Migrate Oracle to Azure Database for PostgreSQL(PAAS) using DMS.
    That scenario isn't supported anymore please check this documentation for the supported scenarios
    If you can afford unavailability of the system for the data migration, the best bet is ora2pg. ora2pg also has a data migration capability. You can use it to move data from Oracle to PostgreSQL.

    Please let us know if the information is helpful.

    Regards
    Geetha

    1 person found this answer helpful.