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>
 <31fdaf33-f401-20ab-9f98-5bedb88448d9@matrix.gatewaynet.com>
 <11cc896e-f136-1e9e-c4ff-ef7939a14337@sqlexec.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <d9ec0ec1-34a6-e46e-25d9-0cb0dd2ef628@matrix.gatewaynet.com>
Date: Thu, 13 Jan 2022 16:37:22 +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: <11cc896e-f136-1e9e-c4ff-ef7939a14337@sqlexec.com>
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/d9ec0ec1-34a6-e46e-25d9-0cb0dd2ef628%40matrix.gatewaynet.com>
Precedence: bulk

On 13/1/22 4:28 μ.μ., MichaelDBA wrote:
Hi Michael, thank you
> As an ex-PB programmer, you should recompile the PowerBuilder app.  It is probably using "datawindows" to abstract the SQL away.  This way you can catch any incompatibilities and fix the datawindows 
> accordingly.  Obviously, you have to provide a different database driver as well.  What version of PB are you using?
>
Yes they do use datawindows, do not know version yet.
> Regards,
> Michael Vitale
>
>
> Achilleas Mantzios wrote on 1/13/2022 9:20 AM:
>> On 13/1/22 4:13 μ.μ., Julien Rouhaud wrote:
>>> On Thu, Jan 13, 2022 at 04:06:06PM +0200, Achilleas Mantzios wrote:
>>>> Dziekuje Alicija. The powerbuilder app is in-house developed, source is
>>>> available, what could be wrong with the app? Browsing through the
>>>> powerbuilder source I don't see (by eye) anything that could break something
>>>> in PgSQL.
>>> 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).
>>>
>>> [1] https://ora2pg.darold.net/documentation.html#Migration-cost-assessment
>> Such great info. Thank you so much. 21 years ago we started building our system on top of PostgreSQL, there have been challenges, but we never regreted our initial decision (vs mysql) not even once.
>>
>>
>
>
>


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