Online Oracle to azure PostgreSQL migration

Siddharth Pawar 0 Reputation points
2024-02-05T09:48:15.0366667+00:00

Hi, We are planning to migrate 2TB Oracle database from on prem to Azure PostgreSQL. For schema conversion and migration we are planning to do with Ora2PG or Ispirer. Where we will convert schema and objects under them using one of these tools and migrate it do target PostgreSQL database. We want a data migration solution where we will be able to online migrate data from source Oracle database to target PostgreSQL database till the time of cutover. Meaning active replication. There are tools like Oracle Golden Gate or Quest Shareplex which suffice our requirement. My question here is, whether Azure database migration service supports this kind of online data migration(active replication) on cross platform and databases? if yes, some documentation will be really helpful.

Azure Database Migration service
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
958 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 13,441 Reputation points Microsoft Employee
    2024-02-05T10:00:06.6066667+00:00

    Hi Siddharth Pawar •,

    Welcome to Microsoft Q&A forum.

    As I understand, you want to perform online migration of Oracle to Azure PostgreSQL.

    The ora2pg tool connects your Oracle database, scans it automatically, and extracts its structure or data. Then ora2pg generates SQL scripts that you can load into your PostgreSQL database. You can use ora2pg for tasks such as reverse-engineering an Oracle database, migrating a huge enterprise database, or simply replicating some Oracle data into a PostgreSQL database. The tool is easy to use and requires no Oracle database knowledge besides the ability to provide the parameters needed to connect to the Oracle database.

    Refer to the documentation here for complete details:

    https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-from-oracle

    Let us know if this helps. If not, we will continue to engage to understand more on the requirement. Thanks

    0 comments
  2. ShaktiSingh-MSFT 13,441 Reputation points Microsoft Employee
    2024-02-06T07:36:13.6633333+00:00

    Hi Hi Siddharth Pawar •,

    Thanks for the details.

    Your ask is about Azure Database Migration Service (DMS) for Oracle to Azure PostgreSQL MigrationOnline.

    The following table describes the current status of Database Migration Service support for online migrations:

    User's image

    It is not yet available.

    Reference Link: https://learn.microsoft.com/en-us/azure/dms/resource-scenario-status Hope this helps. Thanks

    0 comments