Re: Oracle to PostgreSQL Migration

From: paramjib baruah <paramjibbaruah(at)gmail(dot)com>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc: Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Oracle to PostgreSQL Migration
Date: 2023-03-22 05:27:59
Message-ID: CADoaqLmGW2inpb_i8VwfU7MHP4cX1F9XCaT+BnkiqNQ8=H1N_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(dot)millas(at)mokadb(dot)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(dot)shafiq(at)hotmail(dot)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*
>>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message MS A 2023-03-22 07:05:12 Postgresql professional certification
Previous Message houzj.fnst@fujitsu.com 2023-03-22 01:49:03 RE: Logical replication fails when adding multiple replicas