Online Oracle to azure PostgreSQL migration

Question

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.

Answer 1

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

Answer 2

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:

It is not yet available.

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