Search Postgresql Archives

Re: Oracle to PostgreSQL Migration - Need Information

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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! 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux