From: Kenneth Marshall <ktm@rice.edu>
To: Achilleas Mantzios <achill@matrix.gatewaynet.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 08:12:41 -0600
Message-ID: <20220113141241.GV25601@aart.rice.edu> (raw)
In-Reply-To: <5387d1e8-a7d4-f568-fef1-30489fe93bba@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>
> >Hi Achilleas,
> >I would go with version B - since as I understand it's ISV
> >solution. Meaning the postgres ddl was tested and aligned with the
> >application layer, otherwise you would need to fix app layer after
> >the migration.
> 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.
> >
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
Hi Achilleas,
If the schema and usage is straight-forward, I would recommend using
ora2pg to give you an estimation cost for your migration by letting you
know what cannot be automatically translated. Once you have that you
will be better informed as to the work needed.
Regards,
Ken
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: ktm@rice.edu, achill@matrix.gatewaynet.com, zaledwie10minut@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: New Oracle system in our house, migration chances
In-Reply-To: <20220113141241.GV25601@aart.rice.edu>
* 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