RE: Oracle 11g to PostgreSQL 10 - Database Migration

<soumik.bhattacharjee@xxxxxxx> · Tue, 14 Aug 2018 11:53:19 +0000

Thanks Mariel.

Also if any help on moving the delta part post migration process , any tools which is intelligent enough to identify the
 delta part.

There will be a period of 3 days between Migration and
Cutover(Delta)

Thanks
Soumik

From: Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>

Sent: Tuesday, August 14, 2018 5:06 PM

To: Bhattacharjee, Soumik <soumik.bhattacharjee@xxxxxxx>

Cc: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>

Subject: Re: Oracle 11g to PostgreSQL 10 - Database Migration

Hi,

It is very depends on the structure of your database. Before starting try to know
everything  about your database - schemas, object types and so on.. Ora2pg is a great tool but sometimes isnt enough for all migrations. Check out oracle_fdw("dblink" to oracle database) and orafce (oracle internal functions
 for postgresql).

2018-08-14 14:22 GMT+03:00 <soumik.bhattacharjee@xxxxxxx>:

Hello All,

We have a requirement to migrate from Oracle(Multiple versions) – 11gR1,11gR2,12c to PostgreSQL 10 to private cloud of customer  in context
 to that –

1.      
Please let me know the best practices for migrations- any documents ,links etc.
2.      
Open source tools for migration.
3.      
OS and kernel parameters as per PostgreSQL standards for DB instances.
4.      
Design and planning for PostgreSQL configurations.
5.      
If Ora2pg tool is enough for migration?

Thanks
Soumik