Re: Ora2pg Delta Migration: Oracle to PostgreSQL

From: Muhammad Ikram <mmikram(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Ora2pg Delta Migration: Oracle to PostgreSQL
Date: 2024-05-03 07:24:50
Message-ID: CAGeimVqZ0=n+yPc6O67+08QBS1Gjpz_U7enJAK5ADPQ7pWxaAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Not related to Ora2PG but in the past I have used the EDB Migration toolkit
for such scenarios. Filterprops option can help in specifying filter (where
clause).

Regards,
Ikram

On Fri, May 3, 2024 at 8:12 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:

> On Thu, May 2, 2024 at 8:28 PM Amit Sharma <amitpgsql(at)gmail(dot)com> wrote:
>
>> Hello,
>>
>> Has anyone tried delta/incremental data migration for Oracle to
>> PostgreSQL using Ora2pg? Or what are the best options to run delta
>> migration for Oracle to PostgreSQL?
>>
>
> What do the ora2pg docs say about whether or not that feature is
> implemented? (It wasn't when I last used it in 2022.)
>
>

--
Muhammad Ikram

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Avinash Vallarapu 2024-05-03 09:38:31 Re: Ora2pg Delta Migration: Oracle to PostgreSQL
Previous Message Justin Clift 2024-05-03 04:13:13 Re: Table data migration from single server to Flexi server