RE: Differences between Oracle and Progress, actually starting point for considering any migration from Oracle to anything else...

Oops, I'm sorry for cluttering the list. Not enough coffee in the morning :)

Igor

-----Original Message-----

From: Nigel Thomas [mailto:nigel_cl_thomas_at_yahoo.com] Sent: Tuesday, March 20, 2007 10:30 AM
To: Igor Neyman; oracle-l_at_freelists.org
Subject: Re: Differences between Oracle and Progress, actually starting point for considering any migration from Oracle to anything else...

Igor

The OP specifically asked about the PROGRESS database (see www.progress.com), not PostGres. To be specific, I think it is Progress OpenEdge RDBMS http://www.progress.com/openedge/products/index.ssp (ie not ObjectStore, omne of their more recent acquisitions).

Of course your references and comments are entirely valid for the second part of his question "any migration from Oracle to anything else..."

Regards Nigel

• Original Message ---- From: Igor Neyman <ineyman_at_perceptron.com> To: mwf_at_rsiz.com; kamutandeb_at_gmail.com; oracle-l_at_freelists.org Sent: Tuesday, March 20, 2007 1:02:52 PM Subject: RE: Differences between Oracle and Progress, actually starting point for considering any migration from Oracle to anything else...

Well, Postgres has PlPgSql, which is relatively close to Oracle's PL/SQL.
At least closer, than procedural languages in any other dbms I saw.

But, yes when migrating application from Oracle to PG I did have to modify my PL/SQL packages, triggers, veiw definitions (i.e. replace DECODE functions with "CASE" manually).

Igor

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 20 2007 - 09:46:51 CDT