Oracle to PostgreSQL Migration Planned.

[David Briars]

Our reporting data warehouse is migrating from Oracle to PostgreSQL.  

Our reporting application is mostly TABLEing views and reporting via Excel formatted reports.  

Has anyone worked with a migration like this before and can share any challenges encountered on the reporting application side?    

[Patrick Huebgen]

Hi @David Briars - this depends on what you are changing

If your WebFOCUS repository is moving as well - there are tools/techniques to do this transfer - not too complicated.

If it's "only" your reporting data is will depend on how you move the warehouse - in most cases this could be enough to change the SUFFIX - but very often there will be other changes as well as some datatypes will be different between the data sources.

You can try to recreated some of the masters for PostgreSQL and compare them with the existing Oracle masters (using Winmerge) to learn what is changing and then use Notepad++ for a mass update of the existing masters.

Patrick

 

  

[David Briars]

Thanks Patrick.  Yes, we have created the masters for PostreSQL, and are now comparing them to the masters under Oracle.  

[David Beagan]

It will be interesting to see if you encounter any surprises.

[Patrick Huebgen]

15 hours ago, David Beagan said:

It will be interesting to see if you encounter any surprises.

Great idea - @David Briars keep us in the loop about your findings - maybe we can help and learn at the same time