Re: Oracle 11g to PostgreSQL 10 - Database Migration

Well like I said it depends on your oracle`s database structure(the logical
structure - tables,tablespace and so on..) and on the migration tool that
you will use. If the database are small maybe consider using oracle_fdw to
the oracle`s tables for the deltas. I didnt search online but maybe there
is a tool that can manage logical replication between oracle and postgresql
and that might help you.

2018-08-14 14:53 GMT+03:00 <soumik(dot)bhattacharjee(at)kpn(dot)com>:

> 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(dot)cherkassky(at)gmail(dot)com>
> *Sent:* Tuesday, August 14, 2018 5:06 PM
> *To:* Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com>
> *Cc:* pgsql-admin <pgsql-admin(at)postgresql(dot)org>
> *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(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
>
>
>