Oracle2PostgreSQL Migration with PL/pgSQL

From: Guido Stepken <stepken_at_little-idiot.de>
Date: Sat, 08 Mar 2003 21:22:54 +0100
Message-ID: <b4djf0$beb$06$1@news.t-online.com>

Hi, out there !

I am writing on a Oracle to PostgreSQL migration handbook.

Seems, that PostgreSQL 7.4 (still beta) works quite fine in emulating pl/SQL language. Clustering, MVCC (Multi Versioning Concurrency Control), hot backup ... large databases (> 1 Tera), Query caching/hashing, server side scripting with pl/pgSQL emulation seems to work now. Very powerful RAD tools exist for postgresql. Oracle tools can be used for development, due to compatibility.

PostgreSQL IMHO more and more becomes a Oracle killer. Worth, writing a small book about it ;-)

I am still seeking small documentation / experiences, perhaps pl/SQL -> pl/pgSQL code for comparisons, benchmarks (yes, i know, difficult to interpret), experiences with toolkits (RAD, UML ...)....code should be unter a free license for being published, if possible.......

any hints welcome

tnx in advance, Guido Stepken (mailto:stepken @ little - idiot.de) Received on Sat Mar 08 2003 - 14:22:54 CST