how to user azure dms for oracle postgresql migration

Question

how to user azure dms for oracle postgresql migration

Gatadi Sandeep Kumar 0

steps to migrate oracle to postgesql database.

I am using ora2pg for schema conversion.

For data migration i need steps to user azure DMS service

Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2025-06-03T08:41:53.1533333+00:00

Hi @ Gatadi Sandeep Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Gatadi Sandeep Kumar 0 Reputation points

2025-06-03T08:46:11.1833333+00:00

Unable to find option for oracle in DMS target to postgresql.PLease suggest.
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2025-06-03T16:21:49.45+00:00

Hi @ Gatadi Sandeep Kumar

It looks like Azure Database Migration Service (DMS) does not directly support Oracle as a source for PostgreSQL migration. Instead, Microsoft recommends using Ora2Pg, an open-source tool, for schema conversion and data migration

Here’s what you can do:

Since you're already using Ora2Pg, ensure that your schema is fully converted and optimized for PostgreSQL.

Ora2Pg can also handle data migration. You may need to export data from Oracle using Ora2Pg and then import it into PostgreSQL.
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-05T04:43:20.01+00:00

Hi @ Gatadi Sandeep Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-06T01:05:17.6966667+00:00

Hi @ Gatadi Sandeep Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2025-06-03T08:41:53.1533333+00:00

Hi @ Gatadi Sandeep Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Gatadi Sandeep Kumar 0 Reputation points

2025-06-03T08:46:11.1833333+00:00

Unable to find option for oracle in DMS target to postgresql.PLease suggest.
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2025-06-03T16:21:49.45+00:00

Hi @ Gatadi Sandeep Kumar

It looks like Azure Database Migration Service (DMS) does not directly support Oracle as a source for PostgreSQL migration. Instead, Microsoft recommends using Ora2Pg, an open-source tool, for schema conversion and data migration

Here’s what you can do:

Since you're already using Ora2Pg, ensure that your schema is fully converted and optimized for PostgreSQL.

Ora2Pg can also handle data migration. You may need to export data from Oracle using Ora2Pg and then import it into PostgreSQL.
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-05T04:43:20.01+00:00

Hi @ Gatadi Sandeep Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator

2025-06-06T01:05:17.6966667+00:00

Hi @ Gatadi Sandeep Kumar

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi @ Gatadi Sandeep Kumar

Migrating data from Oracle to PostgreSQL using Azure Database Migration Service (DMS) involves several steps. Since you're already using Ora2Pg for schema conversion, here’s how you can proceed with Azure DMS for data migration:

Steps to Migrate Data Using Azure DMS

Prepare the Source and Target Databases

Ensure your Oracle database is accessible from Azure DMS.

Set up your PostgreSQL instance in Azure.

Configure network settings to allow connectivity between Oracle and PostgreSQL.

Create an Azure DMS Instance

Go to the Azure portal and create a Database Migration Service instance.

Choose the appropriate pricing tier based on your migration needs.

Set Up a Migration Project

In Azure DMS, create a new migration project.

Select Oracle as the source and PostgreSQL as the target.

Choose Online or Offline migration based on your requirements.

Configure Source and Target Connections

Provide Oracle database credentials and connection details.

Enter PostgreSQL database credentials for the target.

Select Tables for Migration

Choose the tables and data you want to migrate.

Azure DMS will assess compatibility and provide recommendations.

Run the Migration

Start the data migration process.

Monitor the migration progress in the Azure portal.

Validate and Optimize

Verify that all data has been migrated successfully.

Perform post-migration validation to ensure data integrity.

Optimize indexes and queries for better performance.

Please go through this Detailed Document: Migrate Oracle to Azure Database for PostgreSQL Using Ora2Pg

Hope this helps. Do let us know if you any further queries.

Share via

how to user azure dms for oracle postgresql migration

1 answer

Your answer