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!
|
