Re: Oracle to PostgreSQL Migration

paramjib baruah <paramjibbaruah@gmail.com>

From: paramjib baruah <paramjibbaruah@gmail.com>
To: Marc Millas <marc.millas@mokadb.com>
Cc: Inzamam Shafiq <inzamam.shafiq@hotmail.com>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-03-22T05:27:59Z
Lists: pgsql-general
EDB has migration toolkit , which is very helpful in migration from Oracle
to EDB.

Thanks and Regards
Paramjib Baruah

On Tue, Mar 21, 2023 at 9:12 PM Marc Millas <marc.millas@mokadb.com> wrote:

> EDB do have a replication server which can be used to transfer real time
> data from oracle to postgres.
> don't know if it can be used to get to "no downtime"
> BTW what do you call "no downtime" as anyway a switch, as fast as it can
> be do take ""some"" time ?
>
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com
>
>
>
> On Mon, Mar 20, 2023 at 1:58 PM Inzamam Shafiq <inzamam.shafiq@hotmail.com>
> wrote:
>
>> Hi,
>>
>> Hope everyone is fine.
>>
>> Can someone help or guide regarding Open Source tools for Oracle to
>> PostgreSQL migration with real time CDC. along with this is there any
>> possibility to change the structure of the database? Let me explain a
>> little more,
>>
>> We have an Oracle DB which is around 1TB and we want to migrate to
>> PostgreSQL that have a new table structure, so we want to perform data
>> transformation and real time CDC from Oracle to PostgreSQL. Do we have any
>> good open source tool to achieve this with No Coding involved.??
>>
>> Thanks.
>>
>> Regards,
>>
>> *Inzamam Shafiq*
>> *Sr. DBA*
>>
>