public inbox for [email protected]
help / color / mirror / Atom feedFrom: Rajesh Kumar <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Oracle to postgres migration
Date: Mon, 27 Jan 2025 15:43:33 +0530
Message-ID: <CAJk5Atakgf2B0dtQLgbsp37ncEh0K0a+cvoC=PzJ0VNQq4D1Pw@mail.gmail.com> (raw)
In-Reply-To: <CAJk5Atb417VyDWX=Ag=RiZxTS2WGjRoWKfzn+iHpHJD7UD=20g@mail.gmail.com>
References: <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
<Z5dQV9IVZcLjKN3b@jrouhaud>
<CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A@mail.gmail.com>
<CANzqJaBAGHKG_Vc38BbLau_UGcvGomm-rFahpAJ814vV3V4fog@mail.gmail.com>
<CAJk5Atb417VyDWX=Ag=RiZxTS2WGjRoWKfzn+iHpHJD7UD=20g@mail.gmail.com>
With regards to lo, is there any difficulty if we have rowsize > 1gb
On Mon, 27 Jan 2025, 15:41 Rajesh Kumar, <[email protected]>
wrote:
> Thank you all. As mush as more info is always appreciated by dearest
> admins
>
> On Mon, 27 Jan 2025, 15:40 Ron Johnson, <[email protected]> wrote:
>
>> I migrated a 12TB Oracle db that was mostly LOB objects into an 8TB PG
>> database. LOBs loaded into bytea columns.
>> One thing which I did not do, but should have, was have ora2pg convert
>> NUMBER(38,0) values to BIGINT.
>>
>> We just used ora2pg to convert data; the app developer rewrote all of the
>> stored procedures, functions, triggers, etc.
>>
>> On Mon, Jan 27, 2025 at 4:31 AM Rajesh Kumar <[email protected]>
>> wrote:
>>
>>> Size is 300gb, have lob objects. I prefer ora2pg. Does EDB MTK costs?
>>>
>>> Mostly I need to know what are all the things I need to ask oracle
>>> people to start withj
>>>
>>> On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, <[email protected]> wrote:
>>>
>>>> Hi,
>>>>
>>>> On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar 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.
>>>> >
>>>> > Where do I start with? Anybody has any documentation related to ora2pg
>>>> > migration ?
>>>>
>>>> ora2pg is probably the best tool for your task. And yes it does provide
>>>> estimates for the migration efforts, see
>>>> https://ora2pg.darold.net/documentation.html#Migration-cost-assessment.
>>>>
>>>> In general the ora2pg documentation is really good, you should find the
>>>> answer
>>>> to all your questions there.
>>>>
>>>
>>
>> --
>> Death to <Redacted>, and butter sauce.
>> Don't boil me, I'm still alive.
>> <Redacted> lobster!
>>
>
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]
Subject: Re: Oracle to postgres migration
In-Reply-To: <CAJk5Atakgf2B0dtQLgbsp37ncEh0K0a+cvoC=PzJ0VNQq4D1Pw@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