Re: Oracle to Postgress Migration - Mailing list pgsql-general

From DAVID ROTH
Subject Re: Oracle to Postgress Migration
Date
Msg-id 716257500.1698550.1657828634247@connect.xfinity.com
Whole thread Raw
In response to Re: Oracle to Postgress Migration  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Looks good.
Thanks

> On 07/14/2022 3:10 PM Bruce Momjian <bruce@momjian.us> wrote:
> 
>  
> On Thu, Jul 14, 2022 at 03:06:58PM -0400, DAVID ROTH wrote:
> > Has anything been published on Oracle to Postgress migration.
> > 
> > I am finding plenty of information about schema migration but,
> > I think this is the easy part.
> > I have a a tremendous amount of SQL and PL/SQL code that needs to be translated.  I know Oracle "packages" will not
translate. DECODE is not standard and will need to be rewritten as CASE.  I have seen feature/function translation
matricesto/from Oracle and other database but I can't seem to find one for Postgress.
 
> > Please point me in the right direction.
> 
> I would start here:
> 
>     https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion
> 
> -- 
>   Bruce Momjian  <bruce@momjian.us>        https://momjian.us
>   EDB                                      https://enterprisedb.com
> 
>   Indecision is a decision.  Inaction is an action.  Mark Batterson



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PostgreSQL 14.4 ERROR: out of memory issues
Next
From: Tomas Vondra
Date:
Subject: Re: PostgreSQL 14.4 ERROR: out of memory issues