| From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
|---|---|
| To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | Alicja Kucharczyk <zaledwie10minut(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: New Oracle system in our house, migration chances |
| Date: | 2022-01-13 14:12:41 |
| Message-ID: | 20220113141241.GV25601@aart.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> >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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2022-01-13 14:13:21 | Re: New Oracle system in our house, migration chances |
| Previous Message | Achilleas Mantzios | 2022-01-13 14:08:16 | Re: New Oracle system in our house, migration chances |