Thread: migrating from Oracle to PostgreSQL 11

Hi,

I think you can start from:

- https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion

-
https://severalnines.com/blog/migrating-oracle-postgresql-what-you-should-know

- http://ora2pg.darold.net/

- https://pgxn.org/dist/orafce/

Regards,

Enrico


Il 26/06/2019 15:42, Hitesh Chadda ha scritto:
> Hi PostgresSQL Support,
>
> I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest
> best solution for doing the migration.
>
> Regards
>
> H.Kumar
>
>
> --
> Questo messaggio è stato analizzato con Libra ESVA ed è risultato non
> infetto.
>
--
Enrico Pirozzi
NBS Group S.r.l.
via Val Tiberina 23/A
63074, San Benedetto del Tronto (AP)
Tel. 0735-7626201

On Wed, 26 Jun 2019 19:12:07 +0530
Hitesh Chadda <hkumarchadda@gmail.com> wrote:

> Hi PostgresSQL Support,
> 
> I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest
> best solution for doing the migration.

Bit of a broad topic for an answer. Other than "carefully", there
isn't enough of a question to answer.

Issues that will affect the transfer include the quantity of data,
relative locations of the servers, complexity of the data, how much
custom code you have tied up in triggers and local functions, and 
the platforms you will be running with.

For example, moving a 6PB database has downtime and data transfer
issues that you don't have with a few GB; a 7x24 database with 
multiple hot servers accessed via VPN has different challenges than
a single-server on a VM on your LAN; translating a bunch of integer
SK's and some text has different requirements than something you want
to compose arrays, ranges, or JSONB objects out of; the dialaects
of PLSQL are not entirely compatible so you will have to think about
translating triggers, reports, and op's code between dialects; Oracle
only supports "global temporary tables", PG avoids them with the 
added features of drop/truncate on commit...

Your best first step will be to get a basic understanding of PG. I
like the "PostgreSQL: Up and Running", I think it's up to the 3rd 
edition. Grab it on Safari, fairly short read covers the topics you
need to get a running PG database.

PG is a moving target: 11 supports all sorts of nice, new things;
12 has even more of them. Pick a PG version (suggest 11, it's 
stable), look at what it does, investigate the specific applications 
you have on site, document them, and start porting them to PG 
from smallest to largest. 

If you have specific questions about the PG version, its features,
or how to translate specific Oracle-isms into PG please feel free
to ask -- that's what we're here for :-) 

-- 
Steven Lembark                                     3920 10th Ave South
Workhorse Computing                               Birmingham, AL 35222
lembark@wrkhors.com                                    +1 888 359 3508

On 11/07/2019 17:53, Hitesh Chadda wrote:
> Hello,
> The target is PostgreSQL 10.1. I would like to know possible approach 
> that can be followed for doing the migration.
>
> Regards
> H.kumar
>
>
>
> On Wednesday, June 26, 2019, Hitesh Chadda <hkumarchadda@gmail.com 
> <mailto:hkumarchadda@gmail.com>> wrote:
>
>     Hi PostgresSQL Support,
>
>     I have to migrate from Oracle 11g to PostgresSQL 11.4. Please
>     suggest best solution for doing the migration.
>
>     Regards
>
>     H.Kumar
>
Hitesh,

Please don't top post, as the convention in these lists is to add new 
stuff at the bottom.

Why not upgrade Oracle to PostgresSQL 11?


Cheers,
Gavin