This is almost exactly what we did around 8 years ago; obviously the version numbers have changed. The reason we chose Postgres was the enormous similarity between the two languages plus the overwhelming ROI on the migration; my CEO had a spontaneous nosebleed when the Oracle licensing costs were revealed one year.
Migration requires some thought, investigation, a clear plan and testing - but I'm probably preaching to the converted. We did it, we've never looked back and have had at least 8 long very happy, stable and productive years and are looking forward to many more (raises a glass to the developers and maintainers). Tim Clarke On 08/07/15 20:24, Tim Clotworthy wrote: > Hello, > > I have a customer that is about to undertake a migration of an Oracle 11g > database to PostgreSQL 9.x (exact version to be determined). I am talking > not only of the migration of schemas and data, but also of a substantial > codebase of Pl/SQL stored procedures, as well as many triggers. > > I don't think they know yet what they are up against. Everything I have > read is that this is a very substantial effort. At this stage, they would > be particularly interested in realistic and practical information on > how to > estimate the effort required as well as any best-practices or guidance on > transition strategies. > > I have found official documentation on the PostgreSQL site for porting > Pl/SQL to PL/pgSQL. This is excellent technical documentation. However, > there success will require that they are well prepared realistically > understanding the scope of the effor they are asbout to undertake. > > Thanks for any response!