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

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