Re: [External] : Oracle to postgresql migration steps.

I miss VMS.

D

On Thu, Feb 8, 2024, 9:58 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On Thu, 2024-02-08 at 14:49 +0000, Jeff Smith wrote:
>
> You’re going in the wrong direction…
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>*On
> Behalf Of *Shravan Kumar Kota
> *Sent:* Thursday, February 8, 2024 7:20 AM
> *To:* Oracle-L Freelists <oracle-l_at_freelists.org>
> *Subject:* [External] : Oracle to postgresql migration steps.
>
>
>
> Hello Experts,
>
>
>
> Did any one migrated the Oracle database into postgresql ?
>
>
>
> If yes, please share the steps or document.
>
>
>
> Thanks,
>
> Shravan.
>
>
> Hi Jeff,
> From the technology point of view, I agree. Technologically, Oracle RDBMS
> is far superior to PostgreSQL. However, the devil is, as they say, in the
> details. Oracle RDBMS is also rather pricey, and companies can save a lot
> of money by switching to Postgres. Every conversion project that I have
> been working on, and all in all there were 4 of them, was motivated by the
> savings that could be realized by converting from Oracle to Postgres. And
> even if you opted for the comfortable route of using EDB, a commercial
> variant of Postgres with native support of PL/SQL and hints, the savings
> will be significant. Furthermore, Postgres dialect of SQL is no longer
> exotic, as many competing databases have adopted the Postgres version of
> SQL (Aurora, Netezza, Greenplum, Edb, Vertica). That means that the
> developers and DBAs are easier to come by and that training is no longer
> that expensive. I have been "downsized" by Barclay's Bank PLC on November
> the 29th, 2023 and was recently looking for a job. I have noticed several
> high profile PostgreSQL postings, with the salaries approaching the
> salaries of Oracle DBA personnel. Postgres is very much in demand and the
> reason for that is the cost of doing business with Oracle Corp.
> A long, long time ago, in the Maynard Mill far, far away, there was a guy
> named Ken Olsen, who was the majority shareholder of the then 2nd largest
> IT company, second only to the then mighty IBM and a legendary, larger than
> life CEO of the Digital Equipment Corporation. Once mighty DEC is now
> completely defunct. One of the reasons was the decision to charge for VMS
> 5.x. VMS 4.x (the last one was 4.7) was completely free, while VMS 5.x was
> rather pricey. And what happened? Customers started exploring Unix. That
> was the thing that has brought down the mighty DEC. It was the golden age
> of the proprietary SVR4 Unix flavors: HP-UX, Dynix, DGUX, Irix, AIX and
> several x86 based Unix systems like SCO, Wyse and AT&T started eating up
> VMS market. And eventually, they ate it completely.
> I would really hate to see the same thing happen to Oracle, the first
> database I have learned and which I still love. However, Oracle is no
> longer the only game in town, we all need to take notice, especially
> Oracle. BTW, I have been hired by Fiserv, to assist with further conversion
> to PostgreSQL.
>
> --
>
> Mladen Gogala
> Database SME
> https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l