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@xxxxxxxxx] 
Sent: Tuesday, March 20, 2007 10:30 AM
To: Igor Neyman; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx>
To: mwf@xxxxxxxx; kamutandeb@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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


Other related posts: