What oracle native features not supported in postgresql

Sabir Laskar 21

What oracle native features not supported in postgresql that need to considered for pre-assessing Oracle databases for conversion to Azure Postgresql.

1 answer

Anurag Sharma 17,606 Reputation points

2021-02-08T04:38:20.803+00:00

Hi @Sabir Laskar , welcome to Microsoft Q&A forum.

You can refer to below article for known issues/limitation when migrating from Oracle to Azure PostgreSQL:

https://learn.microsoft.com/en-us/azure/dms/known-issues-oracle-azure-postgresql-online

Please let us know if this helps or else you need more information.

----------

If answer helps, please mark as 'Accept Answer'
Please sign in to rate this answer.
Sabir Laskar 21 Reputation points

2021-02-08T15:26:41.54+00:00

Thank you for reply @AnuragSharma-MSFT . The link you shared is more specific to limitation of DMS for Online migration. I was looking information more specific about oracle features, which we cannot covert to postgresql.

Anurag Sharma 17,606 Reputation points

2021-02-10T06:58:02.797+00:00

Thanks for reverting back. There is one document I was able to locate that talks about workarounds for oracle features when migrating to Azure PostgreSQL. This also talks about few unsupported features as below. Please check if it helps.

Sabir Laskar 21 Reputation points

2021-02-11T08:52:13.12+00:00

@AnuragSharma-MSFT . One of our application is using Oracle Data Cartridge. Can we consider such application for Oracle to Postgresql Migration. Do you see anything equivalent available in Azure postgresql.

Anurag Sharma 17,606 Reputation points

2021-02-12T07:13:30.837+00:00

Hi @Sabir Laskar , there is not a direct one to one mapping of Oracle Data Cartridge feature in Azure PostgreSQL, but I would suggest you to look into below article and check if it can help in any way:

https://learn.microsoft.com/en-us/azure/postgresql/concepts-extensions

Anurag Sharma 17,606 Reputation points

2021-02-17T05:46:55.857+00:00

Hi @Sabir Laskar , just wanted to check if this helps.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

What oracle native features not supported in postgresql

1 answer

Your answer