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(dot)bhattacharjee(at)kpn(dot)com>:

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