From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Alicja Kucharczyk <zaledwie10minut@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: New Oracle system in our house, migration chances
Date: Thu, 13 Jan 2022 09:28:41 -0500
Message-ID: <11cc896e-f136-1e9e-c4ff-ef7939a14337@sqlexec.com> (raw)
In-Reply-To: <31fdaf33-f401-20ab-9f98-5bedb88448d9@matrix.gatewaynet.com>
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>
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?
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.
>
>
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: pgsql-admin@postgresql.org
Cc: MichaelDBA@sqlexec.com, achill@matrix.gatewaynet.com, rjuju123@gmail.com, zaledwie10minut@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: New Oracle system in our house, migration chances
In-Reply-To: <11cc896e-f136-1e9e-c4ff-ef7939a14337@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox