pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle 11g to PostgreSQL 10 - Database Migration
8+ messages / 3 participants
[nested] [flat]
* Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-14 11:22 soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 8+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-08-14 11:22 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-14 11:36 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 8+ messages in thread
From: Mariel Cherkassky @ 2018-08-14 11:36 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-14 11:53 soumik.bhattacharjee@kpn.com
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-08-14 11:53 UTC (permalink / raw)
To: mariel.cherkassky@gmail.com; +Cc: pgsql-admin
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<mailto: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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-14 11:56 Mariel Cherkassky <mariel.cherkassky@gmail.com>
parent: soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 8+ messages in thread
From: Mariel Cherkassky @ 2018-08-14 11:56 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
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
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-14 12:06 soumik.bhattacharjee@kpn.com
parent: Mariel Cherkassky <mariel.cherkassky@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-08-14 12:06 UTC (permalink / raw)
To: mariel.cherkassky@gmail.com; +Cc: pgsql-admin
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<mailto: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<mailto:mariel.cherkassky@gmail.com>>
Sent: Tuesday, August 14, 2018 5:06 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: pgsql-admin <pgsql-admin@postgresql.org<mailto: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<mailto: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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-16 13:55 Evan Bauer <evanbauer@mac.com>
parent: soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 8+ messages in thread
From: Evan Bauer @ 2018-08-16 13:55 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin@lists.postgresql.org
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 <mailto:eb@evanbauer.com>
> +1 646 641 2973
> Skype: evanbauer
>
>
>
> On Aug 14, 2018, at 08:06, soumik.bhattacharjee@kpn.com <mailto:soumik.bhattacharjee@kpn.com> wrote:
>
>
> Okay Thanks Mariel.
>
> From: Mariel Cherkassky <mariel.cherkassky@gmail.com <mailto:mariel.cherkassky@gmail.com>>
> Sent: Tuesday, August 14, 2018 5:27 PM
> To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com <mailto:soumik.bhattacharjee@kpn.com>>
> Cc: pgsql-admin <pgsql-admin@postgresql.org <mailto: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 <mailto: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 <mailto:mariel.cherkassky@gmail.com>>
> Sent: Tuesday, August 14, 2018 5:06 PM
> To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com <mailto:soumik.bhattacharjee@kpn.com>>
> Cc: pgsql-admin <pgsql-admin@postgresql.org <mailto: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 <mailto: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
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-21 06:43 soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 8+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-08-21 06:43 UTC (permalink / raw)
To: pgsql-admin
Hi All,
Few questions - Related to my previous thread about Oracle to Postgre migrations.
1. In the customer cloud environment we don't have any other access in CLI(Command Line) apart from psql, is this sufficient for migration from Oracle to Postgre?
**pgadmin4 will be there along with psql.
2. The source(Oracle) is external to cloud environment and not in the same namespace. Oracle servers are hosted in on premise DC machines/VM's.
3. The Postgre is provisioned automatically based on Postgre Docker image and It does not include "EDB migration toolkit" which is trail/free version.
**If we change the Docker image and include migration toolkit as part of in Stack Builder ?
Any other points/suggestions which you think is important for the migrations?
Thanks
Soumik
From: Bhattacharjee, Soumik
Sent: Tuesday, August 14, 2018 4:52 PM
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Oracle 11g to PostgreSQL 10 - Database Migration
Importance: High
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: Oracle 11g to PostgreSQL 10 - Database Migration
@ 2018-08-21 11:05 soumik.bhattacharjee@kpn.com
0 siblings, 0 replies; 8+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-08-21 11:05 UTC (permalink / raw)
To: pgsql-admin
Hi Team/Experts,
Please let me know your suggestions.
Thanks
Soumik
From: Bhattacharjee, Soumik
Sent: Tuesday, August 21, 2018 12:13 PM
To: 'pgsql-admin@Postgressql.org' <pgsql-admin@Postgressql.org>
Subject: RE: Oracle 11g to PostgresSQL 10 - Database Migration
Hi All,
Few questions - Related to my previous thread about Oracle to Postgres migrations.
1. In the customer cloud environment we don't have any other access in CLI(Command Line) apart from psql, is this sufficient for migration from Oracle to Postgres?
**pgadmin4 will be there along with psql.
2. The source(Oracle) is external to cloud environment and not in the same namespace. Oracle servers are hosted in on premise DC machines/VM's.
3. The Postgres is provisioned automatically based on Postgres Docker image and It does not include "EDB migration toolkit" which is trail/free version.
**If we change the Docker image and include migration toolkit as part of in Stack Builder ?
Any other points/suggestions which you think is important for the migrations?
Thanks
Soumik
From: Bhattacharjee, Soumik
Sent: Tuesday, August 14, 2018 4:52 PM
To: 'pgsql-admin@Postgressql.org' <pgsql-admin@Postgressql.org<mailto:pgsql-admin@postgresql.org>>
Subject: Oracle 11g to PostgresSQL 10 - Database Migration
Importance: High
Hello All,
We have a requirement to migrate from Oracle(Multiple versions) - 11gR1,11gR2,12c to PostgresSQL 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 PostgresSQL standards for DB instances.
4. Design and planning for PostgresSQL configurations.
5. If Ora2pg tool is enough for migration?
Thanks
Soumik
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2018-08-21 11:05 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-08-14 11:22 Oracle 11g to PostgreSQL 10 - Database Migration soumik.bhattacharjee@kpn.com
2018-08-14 11:36 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-08-14 11:53 ` soumik.bhattacharjee@kpn.com
2018-08-14 11:56 ` Mariel Cherkassky <mariel.cherkassky@gmail.com>
2018-08-14 12:06 ` soumik.bhattacharjee@kpn.com
2018-08-16 13:55 ` Evan Bauer <evanbauer@mac.com>
2018-08-21 06:43 RE: Oracle 11g to PostgreSQL 10 - Database Migration soumik.bhattacharjee@kpn.com
2018-08-21 11:05 RE: Oracle 11g to PostgreSQL 10 - Database Migration soumik.bhattacharjee@kpn.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox