public inbox for [email protected]  

help / color / mirror / Atom feed
From: Raphael Salguero Aragón <[email protected]>
To: Kashif Zeeshan <[email protected]>
Cc: Rajesh Kumar <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Oracle to postgres migration
Date: Mon, 27 Jan 2025 10:21:26 +0100
Message-ID: <CAA2=wKaQeJxmwnhf5NWgKFCD5EM8D92wPSzDFfVnp0jgnaddVA@mail.gmail.com> (raw)
In-Reply-To: <CAAPsdheTVs5vaD+zKjwD300M4d1q6qUjPoWTRsM1r5G0iuRDjg@mail.gmail.com>
References: <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
	<CAAPsdheTVs5vaD+zKjwD300M4d1q6qUjPoWTRsM1r5G0iuRDjg@mail.gmail.com>

Hi Rajesh,

ora2pg is a good starting point to get an overview about the complexity.
But the effort for manual conversion also depends on your experiences and
skills. That’s something you can adjust with the cost factors using ora2pg.
Data migration is a different aspect. That depends on the db size, your
object types and the migration method.

I would suggest to get started with ora2pg first.

Best regards
Raphael

Kashif Zeeshan <[email protected]> schrieb am Mo. 27. Jan. 2025 um
10:15:

> Hi Rajesh
>
> You can use EDB's Migration ToolKit (MTK) and following is the link to the
> documentation.
>
> https://www.enterprisedb.com/docs/migration_toolkit/latest/
>
>
> On Mon, Jan 27, 2025 at 2:12 PM Rajesh Kumar <[email protected]>
> wrote:
>
>> Hi team,
>>
>> I am trying to migrate from oracle to postgres.
>>
>> I have been asked to provide an estimation for effort days. Anybody has
>> any document related to estimation? And steps.
>>
>
> The time depends on the size of the data needed to migrate.
>
> Thanks
> Kashif Zeeshan
>
>
>>
>> Where do I start with? Anybody has any documentation related to ora2pg
>> migration ?
>>
>> A little help is appreciated
>>
>


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Oracle to postgres migration
  In-Reply-To: <CAA2=wKaQeJxmwnhf5NWgKFCD5EM8D92wPSzDFfVnp0jgnaddVA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox