Subject: Re: New Oracle system in our house, migration chances
To: pgsql-admin@lists.postgresql.org
References: <d57a8b83-9ea4-97e7-4b72-720932d40fc1@matrix.gatewaynet.com>
 <CAM=sWa6ydVoznn0EOpy1EhYQAuNgVf36gbUgHk9vijLxoTnOWQ@mail.gmail.com>
 <5387d1e8-a7d4-f568-fef1-30489fe93bba@matrix.gatewaynet.com>
 <20220113141321.qdas6evcuc5vvfvp@jrouhaud>
 <87b3dd77-f6c8-1e0c-fcc8-2b2aabefb72b@gmx.net>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <28f5dfe5-fdf6-5d25-8fbf-77075a55a28c@matrix.gatewaynet.com>
Date: Thu, 13 Jan 2022 16:54:05 +0200
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: <87b3dd77-f6c8-1e0c-fcc8-2b2aabefb72b@gmx.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/28f5dfe5-fdf6-5d25-8fbf-77075a55a28c%40matrix.gatewaynet.com>
Precedence: bulk

On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
> Julien Rouhaud schrieb am 13.01.2022 um 15:13:
>> I would go with option A if possible.  If you want to get an idea of how
>> complicated a migration would be, ora2pg does have a migration cost assessment
>> report [1].  It can even check the queries if you have the audit trail enabled
>> on your oracle database (if that existed in that version).
>>
> I second this. Option A) is much cleaner. In my experience compatibility layers
> that promise that "System A" behaves exactly like "System B" also introduce
> a lot of additional problems. And if something goes wrong, you can never be sure
> which part causes the problem.
Thanks, of course I agree with the last sentence.
>
>
>


-- 
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt