Обсуждение: Oracle 11g to PostgreSQL 10 - Database Migration

Поиск
Список
Период
Сортировка

Oracle 11g to PostgreSQL 10 - Database Migration

От
Дата:

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

Re: Oracle 11g to PostgreSQL 10 - Database Migration

От
Mariel Cherkassky
Дата:
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@kpn.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


RE: Oracle 11g to PostgreSQL 10 - Database Migration

От
Дата:

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@gmail.com>
Sent: Tuesday, August 14, 2018 5:06 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.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.bhattacharjee@kpn.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

 

Re: Oracle 11g to PostgreSQL 10 - Database Migration

От
Mariel Cherkassky
Дата:
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.bhattacharjee@kpn.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.cherkassky@gmail.com>
Sent: Tuesday, August 14, 2018 5:06 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.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.bhattacharjee@kpn.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

 


RE: Oracle 11g to PostgreSQL 10 - Database Migration

От
Дата:

 

Okay Thanks Mariel.

 

From: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Sent: Tuesday, August 14, 2018 5:27 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: 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.bhattacharjee@kpn.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.cherkassky@gmail.com>
Sent: Tuesday, August 14, 2018 5:06 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.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.bhattacharjee@kpn.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

 

 

Re: Oracle 11g to PostgreSQL 10 - Database Migration

От
Evan Bauer
Дата:
Soumik,

You are most welcome.

Cheers,

- Evan

Evan Bauer
eb@evanbauer.com
+1 646 641 2973
Skype: evanbauer


On Aug 16, 2018, at 03:53, soumik.bhattacharjee@kpn.com wrote:

Thanks Evan for your valuable inputs.
 
 
 
From: Evan Bauer <evanbauer@mac.com> 
Sent: Tuesday, August 14, 2018 7:27 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Subject: Re: Oracle 11g to PostgreSQL 10 - Database Migration
 
Soumik,
 
Take a look at Talend Open Studio — it includes an open source change data capture capability that supports both Oracle and PostgreSQL.  Setting it up is a bit of a fit, but it may be a robust way to provide the logical replication you need for your database migration.  Talend has both community (Apache licensed) and commercial licensing options.  Most other quality CDC products I’ve used are commercial/proprietary (IBM Infosphere and Oracle GoldenGate), good products but heavyweight and expensive, 
 
Cheers,
 
- Evan
 

Evan Bauer
eb@evanbauer.com
+1 646 641 2973
Skype: evanbauer



On Aug 14, 2018, at 08:06, soumik.bhattacharjee@kpn.com wrote:
 
 
Okay Thanks Mariel.
 
From: Mariel Cherkassky <mariel.cherkassky@gmail.com> 
Sent: Tuesday, August 14, 2018 5:27 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: 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.bhattacharjee@kpn.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.cherkassky@gmail.com> 
Sent: Tuesday, August 14, 2018 5:06 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin <pgsql-admin@postgresql.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.bhattacharjee@kpn.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