Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqIkx-0001CR-O2 for pgsql-admin@arkaria.postgresql.org; Thu, 16 Aug 2018 13:56:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fqIkw-0005ps-7x for pgsql-admin@arkaria.postgresql.org; Thu, 16 Aug 2018 13:56:06 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqIkv-0005pl-ON for pgsql-admin@lists.postgresql.org; Thu, 16 Aug 2018 13:56:06 +0000 Received: from st14p37im-asmtp002.me.com ([17.41.209.31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fqIks-0005ji-UW for pgsql-admin@lists.postgresql.org; Thu, 16 Aug 2018 13:56:04 +0000 Received: from process-dkim-sign-daemon.st14p37im-asmtp002.me.com by st14p37im-asmtp002.me.com (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31 2018)) id <0PDK006003X6IR00@st14p37im-asmtp002.me.com> for pgsql-admin@lists.postgresql.org; Thu, 16 Aug 2018 13:55:59 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mac.com; s=04042017; t=1534427759; bh=wwrvruTlx/hpV8fGYGC2WllOZ5aGWwM7bahbdz+26+w=; h=From:Message-id:Content-type:MIME-version:Subject:Date:To; b=nYwFscuKLV7haPaGr4kOOWUDG6Nt44KuT8/nKXfhlOfiorFpBvsTPwesh76jYLJNu mz3aiC0gCaT6XS9Pw7PJnlLt3caGiYLwtRVFfOEKtvoUPdwuRlO+wk3Kw1VzUG4+T4 gefUBJxjLVIw1QuGi4W0ObvozhZm+mL3pCzWOA/ApSvcmrAGpEex1pnE7LksPhWE6Q pbnbRiWTzPNm9pvo9Z6d2ZPVLEz1ETf/mvJRaJ65VRegvKUBflRTew/KzpeNuYSB/c I2aF58rbEUF1ig6Jo6F3v2aAlhkGcXYqa1Nt8DU/MpO7cqkW4PvfIf0ahRhM8PJVsF nXEMTbivWfHZw== Received: from icloud.com ([127.0.0.1]) by st14p37im-asmtp002.me.com (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31 2018)) with ESMTPSA id <0PDK00650419KH00@st14p37im-asmtp002.me.com>; Thu, 16 Aug 2018 13:55:59 +0000 (GMT) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 clxscore=1015 suspectscore=1 malwarescore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1707230000 definitions=main-1808160145 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-08-16_03:,, signatures=0 From: Evan Bauer Message-id: Content-type: multipart/alternative; boundary="Apple-Mail=_4CE4296B-2F13-495C-AB03-CC549FAEAD24" MIME-version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\)) Subject: Re: Oracle 11g to PostgreSQL 10 - Database Migration Date: Thu, 16 Aug 2018 09:55:57 -0400 In-reply-to: <2A91BEF8171A5349931391E0C721CC53013F05D6@CPEMS-KPN501.KPNCNL.LOCAL> Cc: pgsql-admin@lists.postgresql.org To: soumik.bhattacharjee@kpn.com References: <2A91BEF8171A5349931391E0C721CC53013F0433@CPEMS-KPN501.KPNCNL.LOCAL> <2A91BEF8171A5349931391E0C721CC53013F0456@CPEMS-KPN501.KPNCNL.LOCAL> <2A91BEF8171A5349931391E0C721CC53013F046F@CPEMS-KPN501.KPNCNL.LOCAL> <2A91BEF8171A5349931391E0C721CC53013F05D6@CPEMS-KPN501.KPNCNL.LOCAL> X-Mailer: Apple Mail (2.3445.9.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_4CE4296B-2F13-495C-AB03-CC549FAEAD24 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > Thanks Evan for your valuable inputs. > =20 > =20 > =20 > From: Evan Bauer =20 > Sent: Tuesday, August 14, 2018 7:27 PM > To: Bhattacharjee, Soumik > Subject: Re: Oracle 11g to PostgreSQL 10 - Database Migration > =20 > Soumik, > =20 > Take a look at Talend Open Studio =E2=80=94 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=E2=80=99ve used are = commercial/proprietary (IBM Infosphere and Oracle GoldenGate), good = products but heavyweight and expensive,=20 > =20 > Cheers, > =20 > - Evan > =20 > Evan Bauer > eb@evanbauer.com > +1 646 641 2973 > Skype: evanbauer >=20 >=20 >=20 > On Aug 14, 2018, at 08:06, soumik.bhattacharjee@kpn.com = wrote: > =20 > =20 > Okay Thanks Mariel. > =20 > From: Mariel Cherkassky >=20 > Sent: Tuesday, August 14, 2018 5:27 PM > To: Bhattacharjee, Soumik > > Cc: pgsql-admin > > Subject: Re: Oracle 11g to PostgreSQL 10 - Database Migration > =20 > 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. > =20 > 2018-08-14 14:53 GMT+03:00 >: > Thanks Mariel. > =20 > Also if any help on moving the delta part post migration process , any = tools which is intelligent enough to identify the delta part. > =20 > There will be a period of 3 days between Migration and Cutover(Delta) > =20 > Thanks > Soumik > =20 > =20 > From: Mariel Cherkassky >=20 > Sent: Tuesday, August 14, 2018 5:06 PM > To: Bhattacharjee, Soumik > > Cc: pgsql-admin > > Subject: Re: Oracle 11g to PostgreSQL 10 - Database Migration > =20 > 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). > =20 > 2018-08-14 14:22 GMT+03:00 >: > Hello All, > =20 > We have a requirement to migrate from Oracle(Multiple versions) =E2=80=93= 11gR1,11gR2,12c to PostgreSQL 10 to private cloud of customer in = context to that =E2=80=93 > =20 > 1. Please let me know the best practices for migrations- any = documents ,links etc. >=20 > 2. Open source tools for migration. >=20 > 3. OS and kernel parameters as per PostgreSQL standards for DB = instances. >=20 > 4. Design and planning for PostgreSQL configurations. >=20 > 5. If Ora2pg tool is enough for migration? >=20 > =20 > =20 > Thanks > Soumik --Apple-Mail=_4CE4296B-2F13-495C-AB03-CC549FAEAD24 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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 =E2=80=94= 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=E2=80=99ve 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) =E2=80=93 = 11gR1,11gR2,12c to PostgreSQL 10 to private cloud of customer  in = context to that =E2=80=93
 

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
<= /div>
<= /div>

= --Apple-Mail=_4CE4296B-2F13-495C-AB03-CC549FAEAD24--