Investor Analytics recently completed migration of their @1TB production database from Oracle 8i (8.1.6) to PosgreSQL v9.1.5. The process from start (original proof of concept/business case/due diligence) to switchover took close to a year. There were many parts of the process that were unique to oracle->PG, some unique to that particular version of oracle, and many that were general issues endemic to any large scale data conversion.
Topics to be covered:
1. Business case/due diligence
2. Data conversion
3. Application/Query conversion and issues
4. QA, QA, and more QA
5. General pointers about the whole experience
About the Speaker
Andrew Rawnsley is Managing Director, Technology & Architecture at Investor Analytics LLC, where he oversees application development, production technology, and database management, a position he has held since 2005. Prior to that he was founder and President of The Ravensfield Digital Resource Group.
He has been a PostgreSQL user since the 6.5 days, first applying it to geographic data management and GIS, then to applications in the financial industry.
About Investors Analytics LLC
Investor Analytics LLC, with offices in New York and London, is an award-winning leader in Risk Management services to the world's financial institutions, analyzing over $250B of assets every day. We pride ourselves on the quality of our services, our innovation and creativity, the practicality
of our solutions and the relationships we have with our clients. We are a privately owned business with a strong entrepreneurial spirit where like-minded professionals work in a collaborative environment.