pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNew Oracle system in our house, migration chances
24+ messages / 8 participants
[nested] [flat]
* New Oracle system in our house, migration chances
@ 2022-01-13 12:25 Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 12:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi All, HPNY 2022
We acquired a new company, those guys run on Oracle 10, on AIX 5.2, both systems dating to around 2006 or so.
We would like to increase our chances of recovery in case of disaster, since those are unsupported versions of Oracle/AIX AFAIK.
The application is written on powerbuilder.
The ppl in the respective IT dept claim they have no exotic SQL inside powerbuilder. I am almost 21 years into PostgreSQL, I have done some MS SQL integration with PostgreSQL but almost no Oracle
experience since 90's. What are my options here?
A)
1) use a tool like ora2pg and try to migrate the schema
2) try to load the data
3) migrate ORACLE code procedures and triggers (about 50 in total)
4) setup and test the app
or
B)
1) use a layer that provides DB code (procedures/triggers) compatibility and/or DDL compatibility
2) use a tool to move/migrate the schema and load data
3) setup and test the app
Any hints where to start, technical options, help to evaluate/assess various solutions/costs would be welcome.
I know this has been discussed extensively in PgSQL community, my intention is for this email to provide a platform along with my concurrent/parallel reading on the matter.
Thank you
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 12:39 Alicja Kucharczyk <zaledwie10minut@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 2 replies; 24+ messages in thread
From: Alicja Kucharczyk @ 2022-01-13 12:39 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org
czw., 13 sty 2022 o 13:26 Achilleas Mantzios <achill@matrix.gatewaynet.com>
napisał(a):
> Hi All, HPNY 2022
>
> We acquired a new company, those guys run on Oracle 10, on AIX 5.2, both
> systems dating to around 2006 or so.
> We would like to increase our chances of recovery in case of disaster,
> since those are unsupported versions of Oracle/AIX AFAIK.
> The application is written on powerbuilder.
>
> The ppl in the respective IT dept claim they have no exotic SQL inside
> powerbuilder. I am almost 21 years into PostgreSQL, I have done some MS SQL
> integration with PostgreSQL but almost no Oracle
> experience since 90's. What are my options here?
>
> A)
> 1) use a tool like ora2pg and try to migrate the schema
> 2) try to load the data
> 3) migrate ORACLE code procedures and triggers (about 50 in total)
> 4) setup and test the app
> or
> B)
> 1) use a layer that provides DB code (procedures/triggers) compatibility
> and/or DDL compatibility
> 2) use a tool to move/migrate the schema and load data
> 3) setup and test the app
>
> Any hints where to start, technical options, help to evaluate/assess
> various solutions/costs would be welcome.
>
> I know this has been discussed extensively in PgSQL community, my
> intention is for this email to provide a platform along with my
> concurrent/parallel reading on the matter.
>
> Thank you
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
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.
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 12:45 Jeremiah Bauer <jbauer@agristats.com>
parent: Alicja Kucharczyk <zaledwie10minut@gmail.com>
1 sibling, 1 reply; 24+ messages in thread
From: Jeremiah Bauer @ 2022-01-13 12:45 UTC (permalink / raw)
To: Alicja Kucharczyk <zaledwie10minut@gmail.com>; Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
czw., 13 sty 2022 o 13:26 Achilleas Mantzios <achill@matrix.gatewaynet.com<mailto:achill@matrix.gatewaynet.com>> napisał(a):
Hi All, HPNY 2022
We acquired a new company, those guys run on Oracle 10, on AIX 5.2, both systems dating to around 2006 or so.
We would like to increase our chances of recovery in case of disaster, since those are unsupported versions of Oracle/AIX AFAIK.
The application is written on powerbuilder.
The ppl in the respective IT dept claim they have no exotic SQL inside powerbuilder. I am almost 21 years into PostgreSQL, I have done some MS SQL integration with PostgreSQL but almost no Oracle
experience since 90's. What are my options here?
A)
1) use a tool like ora2pg and try to migrate the schema
2) try to load the data
3) migrate ORACLE code procedures and triggers (about 50 in total)
4) setup and test the app
or
B)
1) use a layer that provides DB code (procedures/triggers) compatibility and/or DDL compatibility
2) use a tool to move/migrate the schema and load data
3) setup and test the app
Any hints where to start, technical options, help to evaluate/assess various solutions/costs would be welcome.
I know this has been discussed extensively in PgSQL community, my intention is for this email to provide a platform along with my concurrent/parallel reading on the matter.
Thank you
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
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.
I agree with Alicja, we have used EnterpriseDB's Oracle compatibility layer to migrate off Oracle in the past.
CONFIDENTIALITY NOTICE: The information contained in this email (and any attachments) is privileged and confidential and protected from disclosure. If you are not the intended recipient of this email or the attachments, be aware that any disclosure, copying, distribution or use of this email or any attachment is strictly prohibited and you should not read the message or read or open any attachment. If you have received this email by mistake, please immediately notify the sender and delete it permanently from your system. Agri Stats, Inc. and its subsidiaries will not be held liable to any person or entity resulting from the unintended or unauthorized use of any information contained in this email.
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:06 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Alicja Kucharczyk <zaledwie10minut@gmail.com>
1 sibling, 2 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 14:06 UTC (permalink / raw)
To: Alicja Kucharczyk <zaledwie10minut@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On 13/1/22 2:39 μ.μ., Alicja Kucharczyk wrote:
> czw., 13 sty 2022 o 13:26 Achilleas Mantzios <achill@matrix.gatewaynet.com <mailto:achill@matrix.gatewaynet.com>> napisał(a):
>
> Hi All, HPNY 2022
>
> We acquired a new company, those guys run on Oracle 10, on AIX 5.2, both systems dating to around 2006 or so.
> We would like to increase our chances of recovery in case of disaster, since those are unsupported versions of Oracle/AIX AFAIK.
> The application is written on powerbuilder.
>
> The ppl in the respective IT dept claim they have no exotic SQL inside powerbuilder. I am almost 21 years into PostgreSQL, I have done some MS SQL integration with PostgreSQL but almost no Oracle
> experience since 90's. What are my options here?
>
> A)
> 1) use a tool like ora2pg and try to migrate the schema
> 2) try to load the data
> 3) migrate ORACLE code procedures and triggers (about 50 in total)
> 4) setup and test the app
> or
> B)
> 1) use a layer that provides DB code (procedures/triggers) compatibility and/or DDL compatibility
> 2) use a tool to move/migrate the schema and load data
> 3) setup and test the app
>
> Any hints where to start, technical options, help to evaluate/assess various solutions/costs would be welcome.
>
> I know this has been discussed extensively in PgSQL community, my intention is for this email to provide a platform along with my concurrent/parallel reading on the matter.
>
> Thank you
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>
>
> 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
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:08 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Jeremiah Bauer <jbauer@agristats.com>
0 siblings, 0 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 14:08 UTC (permalink / raw)
To: Jeremiah Bauer <jbauer@agristats.com>; Alicja Kucharczyk <zaledwie10minut@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On 13/1/22 2:45 μ.μ., Jeremiah Bauer wrote:
> czw., 13 sty 2022 o 13:26 Achilleas Mantzios <achill@matrix.gatewaynet.com <mailto:achill@matrix.gatewaynet.com>> napisał(a):
>
> Hi All, HPNY 2022
>
> We acquired a new company, those guys run on Oracle 10, on AIX 5.2, both systems dating to around 2006 or so.
> We would like to increase our chances of recovery in case of disaster, since those are unsupported versions of Oracle/AIX AFAIK.
> The application is written on powerbuilder.
>
> The ppl in the respective IT dept claim they have no exotic SQL inside powerbuilder. I am almost 21 years into PostgreSQL, I have done some MS SQL integration with PostgreSQL but almost no Oracle
> experience since 90's. What are my options here?
>
> A)
> 1) use a tool like ora2pg and try to migrate the schema
> 2) try to load the data
> 3) migrate ORACLE code procedures and triggers (about 50 in total)
> 4) setup and test the app
> or
> B)
> 1) use a layer that provides DB code (procedures/triggers) compatibility and/or DDL compatibility
> 2) use a tool to move/migrate the schema and load data
> 3) setup and test the app
>
> Any hints where to start, technical options, help to evaluate/assess various solutions/costs would be welcome.
>
> I know this has been discussed extensively in PgSQL community, my intention is for this email to provide a platform along with my concurrent/parallel reading on the matter.
>
> Thank you
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>
> 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.
>
> I agree with Alicja, we have used EnterpriseDB's Oracle compatibility layer to migrate off Oracle in the past.
Thank you Jeremiah.
>
> CONFIDENTIALITY NOTICE: The information contained in this email (and any attachments) is privileged and confidential and protected from disclosure. If you are not the intended recipient of this
> email or the attachments, be aware that any disclosure, copying, distribution or use of this email or any attachment is strictly prohibited and you should not read the message or read or open any
> attachment. If you have received this email by mistake, please immediately notify the sender and delete it permanently from your system. Agri Stats, Inc. and its subsidiaries will not be held liable
> to any person or entity resulting from the unintended or unauthorized use of any information contained in this email.
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:12 Kenneth Marshall <ktm@rice.edu>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 1 reply; 24+ messages in thread
From: Kenneth Marshall @ 2022-01-13 14:12 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: Alicja Kucharczyk <zaledwie10minut@gmail.com>; pgsql-admin@lists.postgresql.org
> >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
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:13 Julien Rouhaud <rjuju123@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 2 replies; 24+ messages in thread
From: Julien Rouhaud @ 2022-01-13 14:13 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: Alicja Kucharczyk <zaledwie10minut@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:15 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Kenneth Marshall <ktm@rice.edu>
0 siblings, 1 reply; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 14:15 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 13/1/22 4:12 μ.μ., Kenneth Marshall wrote:
>>> 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.
Thank you Ken!
>
> Regards,
> Ken
>
>
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:20 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 1 reply; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 14:20 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: Alicja Kucharczyk <zaledwie10minut@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:28 MichaelDBA <MichaelDBA@sqlexec.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 24+ messages in thread
From: MichaelDBA @ 2022-01-13 14:28 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: Julien Rouhaud <rjuju123@gmail.com>; Alicja Kucharczyk <zaledwie10minut@gmail.com>; pgsql-admin@lists.postgresql.org
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.
>
>
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:37 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: MichaelDBA <MichaelDBA@sqlexec.com>
0 siblings, 0 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 14:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:51 Thomas Kellerer <shammat@gmx.net>
parent: Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 1 reply; 24+ messages in thread
From: Thomas Kellerer @ 2022-01-13 14:51 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Julien Rouhaud schrieb am 13.01.2022 um 15:13:
> 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).
>
I second this. Option A) is much cleaner. In my experience compatibility layers
that promise that "System A" behaves exactly like "System B" also introduce
a lot of additional problems. And if something goes wrong, you can never be sure
which part causes the problem.
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 14:54 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Thomas Kellerer <shammat@gmx.net>
0 siblings, 1 reply; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 14:54 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
> Julien Rouhaud schrieb am 13.01.2022 um 15:13:
>> 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).
>>
> I second this. Option A) is much cleaner. In my experience compatibility layers
> that promise that "System A" behaves exactly like "System B" also introduce
> a lot of additional problems. And if something goes wrong, you can never be sure
> which part causes the problem.
Thanks, of course I agree with the last sentence.
>
>
>
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 15:02 Alicja Kucharczyk <zaledwie10minut@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 24+ messages in thread
From: Alicja Kucharczyk @ 2022-01-13 15:02 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org
czw., 13 sty 2022 o 15:54 Achilleas Mantzios <achill@matrix.gatewaynet.com>
napisał(a):
> On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
> > Julien Rouhaud schrieb am 13.01.2022 um 15:13:
> >> 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).
> >>
> > I second this. Option A) is much cleaner. In my experience compatibility
> layers
> > that promise that "System A" behaves exactly like "System B" also
> introduce
> > a lot of additional problems. And if something goes wrong, you can never
> be sure
> > which part causes the problem.
> Thanks, of course I agree with the last sentence.
> >
> >
> >
>
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>
>
just to be clear is it an ISV or in-house built system? Because I see two
different answers ...
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 15:06 Ron <ronljohnsonjr@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 2 replies; 24+ messages in thread
From: Ron @ 2022-01-13 15:06 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 1/13/22 8:15 AM, Achilleas Mantzios wrote:
> On 13/1/22 4:12 μ.μ., Kenneth Marshall wrote:
>>>> 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.
> Thank you Ken!
ora2pg worked perfectly for us in migrating 8TB of Oracle 11 data and simple
triggers to Pg 12.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 15:18 Alicja Kucharczyk <zaledwie10minut@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 24+ messages in thread
From: Alicja Kucharczyk @ 2022-01-13 15:18 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
czw., 13 sty 2022 o 16:06 Ron <ronljohnsonjr@gmail.com> napisał(a):
> On 1/13/22 8:15 AM, Achilleas Mantzios wrote:
> > On 13/1/22 4:12 μ.μ., Kenneth Marshall wrote:
> >>>> 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.
> > Thank you Ken!
>
> ora2pg worked perfectly for us in migrating 8TB of Oracle 11 data and
> simple
> triggers to Pg 12.
>
> --
> Angular momentum makes the world go 'round.
>
>
> Just to be clear. There are 2 options:
1. ISV solution that supports both postgres and oracle when you have the
code and db layer aligned to both dbs. In this case it makes no sense to
migrate yourself with ora2pg - then you will be reinventing the wheel and
waste a lot of time for app, db migration and testing. And what will happen
when you will want to upgrade the your app? You want to merge/compare the
code? do the testing? do you really want to waste your time for it?
If you have ddl for postgres shipped by your vendor all you need to do is
data migration.
2. in-house built soft - then ora2pg is your friend
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 16:04 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Alicja Kucharczyk <zaledwie10minut@gmail.com>
0 siblings, 2 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 16:04 UTC (permalink / raw)
To: Alicja Kucharczyk <zaledwie10minut@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On 13/1/22 5:02 μ.μ., Alicja Kucharczyk wrote:
> czw., 13 sty 2022 o 15:54 Achilleas Mantzios <achill@matrix.gatewaynet.com <mailto:achill@matrix.gatewaynet.com>> napisał(a):
>
> On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
> > Julien Rouhaud schrieb am 13.01.2022 um 15:13:
> >> 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).
> >>
> > I second this. Option A) is much cleaner. In my experience compatibility layers
> > that promise that "System A" behaves exactly like "System B" also introduce
> > a lot of additional problems. And if something goes wrong, you can never be sure
> > which part causes the problem.
> Thanks, of course I agree with the last sentence.
> >
> >
> >
>
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>
>
> just to be clear is it an ISV or in-house built system? Because I see two different answers ...
in-house, and when not in house source is available, can you pls show me where I wrote a conflicting answer?
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 16:05 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 16:05 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 13/1/22 5:06 μ.μ., Ron wrote:
> On 1/13/22 8:15 AM, Achilleas Mantzios wrote:
>> On 13/1/22 4:12 μ.μ., Kenneth Marshall wrote:
>>>>> 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.
>> Thank you Ken!
>
> ora2pg worked perfectly for us in migrating 8TB of Oracle 11 data and simple triggers to Pg 12.
wow! Thank you!
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 16:10 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 0 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 16:10 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 13/1/22 6:04 μ.μ., Achilleas Mantzios wrote:
> On 13/1/22 5:02 μ.μ., Alicja Kucharczyk wrote:
>> czw., 13 sty 2022 o 15:54 Achilleas Mantzios <achill@matrix.gatewaynet.com <mailto:achill@matrix.gatewaynet.com>> napisał(a):
>>
>> On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
>> > Julien Rouhaud schrieb am 13.01.2022 um 15:13:
>> >> 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).
>> >>
>> > I second this. Option A) is much cleaner. In my experience compatibility layers
>> > that promise that "System A" behaves exactly like "System B" also introduce
>> > a lot of additional problems. And if something goes wrong, you can never be sure
>> > which part causes the problem.
>> Thanks, of course I agree with the last sentence.
>> >
>> >
>> >
>>
>>
>> --
>> Achilleas Mantzios
>> DBA, Analyst, IT Lead
>> IT DEPT
>> Dynacom Tankers Mgmt
>>
>>
>>
>> just to be clear is it an ISV or in-house built system? Because I see two different answers ...
>
> in-house, and when not in house source is available, can you pls show me where I wrote a conflicting answer?
to be more clear, they forked the initially ISV 20 years ago, so now there is effectively only in-house.
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 16:11 Alicja Kucharczyk <zaledwie10minut@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
1 sibling, 1 reply; 24+ messages in thread
From: Alicja Kucharczyk @ 2022-01-13 16:11 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org
czw., 13 sty 2022 o 17:04 Achilleas Mantzios <achill@matrix.gatewaynet.com>
napisał(a):
> On 13/1/22 5:02 μ.μ., Alicja Kucharczyk wrote:
>
> czw., 13 sty 2022 o 15:54 Achilleas Mantzios <achill@matrix.gatewaynet.com>
> napisał(a):
>
>> On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
>> > Julien Rouhaud schrieb am 13.01.2022 um 15:13:
>> >> 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).
>> >>
>> > I second this. Option A) is much cleaner. In my experience
>> compatibility layers
>> > that promise that "System A" behaves exactly like "System B" also
>> introduce
>> > a lot of additional problems. And if something goes wrong, you can
>> never be sure
>> > which part causes the problem.
>> Thanks, of course I agree with the last sentence.
>> >
>> >
>> >
>>
>>
>> --
>> Achilleas Mantzios
>> DBA, Analyst, IT Lead
>> IT DEPT
>> Dynacom Tankers Mgmt
>>
>>
>>
> just to be clear is it an ISV or in-house built system? Because I see two
> different answers ...
>
>
> in-house, and when not in house source is available, can you pls show me
> where I wrote a conflicting answer?
>
>
> ok, then sorry for the confusion. I interpreted the answer from Michael
Vitale asking for the version etc. as it would be an ISV which has not
matched with your statement. So in that case I also do vote for A :)
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 18:07 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Alicja Kucharczyk <zaledwie10minut@gmail.com>
0 siblings, 1 reply; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 18:07 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Στις 13/1/22 6:11 μ.μ., ο/η Alicja Kucharczyk έγραψε:
> czw., 13 sty 2022 o 17:04 Achilleas Mantzios
> <achill@matrix.gatewaynet.com <mailto:achill@matrix.gatewaynet.com>>
> napisał(a):
>
> On 13/1/22 5:02 μ.μ., Alicja Kucharczyk wrote:
>> czw., 13 sty 2022 o 15:54 Achilleas Mantzios
>> <achill@matrix.gatewaynet.com
>> <mailto:achill@matrix.gatewaynet.com>> napisał(a):
>>
>> On 13/1/22 4:51 μ.μ., Thomas Kellerer wrote:
>> > Julien Rouhaud schrieb am 13.01.2022 um 15:13:
>> >> 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).
>> >>
>> > I second this. Option A) is much cleaner. In my experience
>> compatibility layers
>> > that promise that "System A" behaves exactly like "System
>> B" also introduce
>> > a lot of additional problems. And if something goes wrong,
>> you can never be sure
>> > which part causes the problem.
>> Thanks, of course I agree with the last sentence.
>> >
>> >
>> >
>>
>>
>> --
>> Achilleas Mantzios
>> DBA, Analyst, IT Lead
>> IT DEPT
>> Dynacom Tankers Mgmt
>>
>>
>>
>> just to be clear is it an ISV or in-house built system? Because I
>> see two different answers ...
>
> in-house, and when not in house source is available, can you pls
> show me where I wrote a conflicting answer?
>
> ok, then sorry for the confusion. I interpreted the answer
> from Michael Vitale asking for the version etc. as it would be an ISV
> which has not matched with your statement. So in that case I also do
> vote for A :)
PowerBuilder was (is?) a development environment/solution which was
blooming back in the client-server era. The language is weird to the
eyes of a java/C/etc person.
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 18:17 MichaelDBA <MichaelDBA@sqlexec.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 2 replies; 24+ messages in thread
From: MichaelDBA @ 2022-01-13 18:17 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin@lists.postgresql.org
Achilleas Mantzios wrote on 1/13/2022 1:07 PM:
> PowerBuilder was (is?) a development environment/solution which was
> blooming back in the client-server era. The language is weird to the
> eyes of a java/C/etc person.
So what's the PB version? v6, v7, v8, v9, 10?, 11.5?
I assume you still have the PG IDE that comes with it, right?
I still have a working copy of 11.5 that I use for some windows GUI tools.
Regards,
Michael Vitale
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-13 19:12 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: MichaelDBA <MichaelDBA@sqlexec.com>
1 sibling, 0 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-13 19:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Στις 13/1/22 8:17 μ.μ., ο/η MichaelDBA έγραψε:
> Achilleas Mantzios wrote on 1/13/2022 1:07 PM:
>> PowerBuilder was (is?) a development environment/solution which was
>> blooming back in the client-server era. The language is weird to the
>> eyes of a java/C/etc person.
>
> So what's the PB version? v6, v7, v8, v9, 10?, 11.5?
No access yet to anything, I asked, still waiting for answer.
>
> I assume you still have the PG IDE that comes with it, right?
>
> I still have a working copy of 11.5 that I use for some windows GUI
> tools.
>
Good to know!
> Regards,
> Michael Vitale
>
>
>
^ permalink raw reply [nested|flat] 24+ messages in thread
* Re: New Oracle system in our house, migration chances
@ 2022-01-14 10:30 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: MichaelDBA <MichaelDBA@sqlexec.com>
1 sibling, 0 replies; 24+ messages in thread
From: Achilleas Mantzios @ 2022-01-14 10:30 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Στις 13/1/22 8:17 μ.μ., ο/η MichaelDBA έγραψε:
> Achilleas Mantzios wrote on 1/13/2022 1:07 PM:
>> PowerBuilder was (is?) a development environment/solution which was
>> blooming back in the client-server era. The language is weird to the
>> eyes of a java/C/etc person.
>
> So what's the PB version? v6, v7, v8, v9, 10?, 11.5?
10.2.1 (Build 9004)
>
> I assume you still have the PG IDE that comes with it, right?
>
yep
> I still have a working copy of 11.5 that I use for some windows GUI
> tools.
>
> Regards,
> Michael Vitale
>
>
>
^ permalink raw reply [nested|flat] 24+ messages in thread
end of thread, other threads:[~2022-01-14 10:30 UTC | newest]
Thread overview: 24+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-01-13 12:25 New Oracle system in our house, migration chances Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 12:39 ` Alicja Kucharczyk <zaledwie10minut@gmail.com>
2022-01-13 12:45 ` Jeremiah Bauer <jbauer@agristats.com>
2022-01-13 14:08 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 14:06 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 14:12 ` Kenneth Marshall <ktm@rice.edu>
2022-01-13 14:15 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 15:06 ` Ron <ronljohnsonjr@gmail.com>
2022-01-13 15:18 ` Alicja Kucharczyk <zaledwie10minut@gmail.com>
2022-01-13 16:05 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 14:13 ` Julien Rouhaud <rjuju123@gmail.com>
2022-01-13 14:20 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 14:28 ` MichaelDBA <MichaelDBA@sqlexec.com>
2022-01-13 14:37 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 14:51 ` Thomas Kellerer <shammat@gmx.net>
2022-01-13 14:54 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 15:02 ` Alicja Kucharczyk <zaledwie10minut@gmail.com>
2022-01-13 16:04 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 16:10 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 16:11 ` Alicja Kucharczyk <zaledwie10minut@gmail.com>
2022-01-13 18:07 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-13 18:17 ` MichaelDBA <MichaelDBA@sqlexec.com>
2022-01-13 19:12 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2022-01-14 10:30 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
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