How to migrate from Oracle Exadata to Azure PostgreSQL DB

Aaron1744 0

Looking for tutorials on migrating Oracle Exadata database to Azure PostgreSQL database. The or2pg tool will not work in this case and can't pay high BYOL for silk or striim.

Can anyone share information on tools and steps to migrate an Exadata DB to Azure PostgreSQL?

Thanks for the help.

2 answers

Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-03-06T00:44:01.06+00:00

@Aaron1744

Thank you for reaching out and for migrating your workload to Azure.

You can try Cortex by Splendid Data to do the conversion of a complex Oracle based system. Cortex is not perfect but provides the cleanest code of the various tools. Please let me know if you are interested as the license cost for Cortex may be covered by us if the opportunity is suitable.

Cortex - Migrate your Oracle® databases to PostgreSQL with ease - Splendid Data

Regards,

Oury
Please sign in to rate this answer.
Aaron1744 0 Reputation points

2024-03-06T14:33:05.01+00:00

Hello Oury,

Thank you for your prompt answer. Me and my team will take a look and see if this can do what we're looking for. In the meantime, how can we receive a license for Cortex?

Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-03-06T18:45:56.4833333+00:00

Aaron1744

You can buy it directly from Splendid Data if you want but you will have to pay for it. If you go through Microsoft, then it is paid by us.

Regards,

Oury

Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-03-06T18:46:55.4333333+00:00

Aaron1744

Please don't forget to mark as accept answer if the reply was helpful. This will be useful for other community members with the same ask.

Regards,

Oury

Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-03-06T21:54:23.17+00:00

Aaron1744

Please don't forget to reach out if you think this is a good solution for you through Microsoft. We can help you with that. Please do also click on the accept answer button.

Regards,

Oury

Aaron1744 0 Reputation points

2024-03-07T13:53:46.16+00:00

Hi Oury

I have setup a demo with Cortex for next week and will check if this is a viable option for our team.

If it is then I will accept the answer, if not, then we'll have to explore alternatives.

Thank you for your help.

Aaron1744 0 Reputation points

2024-03-07T15:08:08+00:00

Hi Oury

Our team has looked into the solution and decided not to move forward with it.

We're looking for something that could be open source and not having another company get involved to interact with the data.

If you know of tutorials/walkthroughs that have been tried and successfully completed please point the way.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Oury Ba-MSFT 18,696 Reputation points Microsoft Employee

2024-03-07T17:21:19.63+00:00
@Aaron1744

I don't know anything else than Ora2Pg. But you can try exploring the below open sources too.

pgloader: An open-source data loading tool that can migrate data from various sources (including Oracle) to PostgreSQL. It supports schema conversion, data transformation, and parallel loading.

Talend: Talend provides an open-source data integration platform that supports Oracle-to-PostgreSQL migration. It offers a visual interface for designing ETL (Extract, Transform, Load) workflows.

Regards,

Oury
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

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

Share via

How to migrate from Oracle Exadata to Azure PostgreSQL DB

2 answers

Your answer