Date: Thu, 13 Jan 2022 08:12:41 -0600
From: Kenneth Marshall <ktm@rice.edu>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: Alicja Kucharczyk <zaledwie10minut@gmail.com>,
	pgsql-admin@lists.postgresql.org
Subject: Re: New Oracle system in our house, migration chances
Message-ID: <20220113141241.GV25601@aart.rice.edu>
References: <d57a8b83-9ea4-97e7-4b72-720932d40fc1@matrix.gatewaynet.com>
 <CAM=sWa6ydVoznn0EOpy1EhYQAuNgVf36gbUgHk9vijLxoTnOWQ@mail.gmail.com>
 <5387d1e8-a7d4-f568-fef1-30489fe93bba@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <5387d1e8-a7d4-f568-fef1-30489fe93bba@matrix.gatewaynet.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Archived-At: 
 <https://www.postgresql.org/message-id/20220113141241.GV25601%40aart.rice.edu>
Precedence: bulk

> >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