From: | Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Oracle to PostgreSQL Migration - Need Information |
Date: | 2015-07-08 19:45:43 |
Message-ID: | 559D7DE7.5090400@manifest.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | John McKown | 2015-07-08 19:47:09 | Re: Oracle to PostgreSQL Migration - Need Information |
Previous Message | Tim Clotworthy | 2015-07-08 19:24:09 | Oracle to PostgreSQL Migration - Need Information |