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

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> wrote:

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

On Thu, Jul 11, 2019 at 1:28 AM Hitesh Chadda <hkumarchadda@gmail.com>
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.
https://why-upgrade.depesz.com/show?from=10.1&amp;to=10.9&amp;keywords=

As Gavin asked, why not start on Pg11 with 11.4 being the current release?

Ryan Lambert