New York City PostgreSQL User Group

Moving from Oracle to PostgreSQL: A Real World Example

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.

Join or login to comment.

  • A former member
    A former member

    very good. could have been a little more technical.

    November 16

  • Mehboob Alam
    Mehboob Alam

    I hope this is still on track, really looking forward to this after the dearth of meetups these last two weeks :(

    November 7

75 attended

Our Sponsors

Yodle

AppNexus

Meeting Location

Slader

Meeting Location

People in this
Meetup are also in:

106,868,938 RSVPs!
hide

Log in

Not registered with us yet?

Forgot your password?

or

Sign up

Meetup members, Log in

or
By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service