how to user azure dms for oracle postgresql migration

Gatadi Sandeep Kumar 0 Reputation points
2025-05-30T14:14:34.6233333+00:00

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

Azure Database Migration service
{count} votes

1 answer

Sort by: Most helpful
  1. Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator
    2025-05-30T14:28:00.0566667+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.