migrating from Oracle to PostgreSQL 11

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

migrating from Oracle to PostgreSQL 11

Hitesh Chadda
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
Reply | Threaded
Open this post in threaded view
|

Re: migrating from Oracle to PostgreSQL 11

Enrico Pirozzi
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




Reply | Threaded
Open this post in threaded view
|

Re: migrating from Oracle to PostgreSQL 11

Steven Lembark
In reply to this post by Hitesh Chadda
On Wed, 26 Jun 2019 19:12:07 +0530
Hitesh Chadda <[hidden email]> 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
[hidden email]                                    +1 888 359 3508


Reply | Threaded
Open this post in threaded view
|

Re: migrating from Oracle to PostgreSQL 11

Hitesh Chadda
In reply to this post by Hitesh Chadda
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: migrating from Oracle to PostgreSQL 11

Gavin Flower-2

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 <[hidden email]
> <mailto:[hidden email]>> 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




Reply | Threaded
Open this post in threaded view
|

Re: migrating from Oracle to PostgreSQL 11

Ryan Lambert
In reply to this post by Hitesh Chadda
On Thu, Jul 11, 2019 at 1:28 AM Hitesh Chadda <[hidden email]> 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

 
10.9 is the current release in Pg10 and contains multiple security fixes over 10.1. There is no good reason to start a new project on an outdated minor release with known security issues. 
 
As Gavin asked, why not start on Pg11 with 11.4 being the current release?

Ryan Lambert