pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle to Postgres
20+ messages / 10 participants
[nested] [flat]
* Oracle to Postgres
@ 2024-07-12 00:02 Sam Stearns <sam.stearns@dat.com>
0 siblings, 5 replies; 20+ messages in thread
From: Sam Stearns @ 2024-07-12 00:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org; +Cc: Catherine Schulz <catherine.schulz@dat.com>; Peter Garza <peter.garza@dat.com>; Henry Ashu <henry.ashu@dat.com>
Howdy,
We have a project to migrate our Oracle databases that are hosted on an
Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
1. Is there a tool out there that we can use to analyze resource sizing
on the Appliance that will give resource sizing recommendations for the VM?
2. Is there a schema conversion tool or similar out there that we can
use to convert Oracle ==> Postgres?
Thanks,
Sam
--
*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 01:01 Keith Christian <keith1christian@gmail.com>
parent: Sam Stearns <sam.stearns@dat.com>
4 siblings, 0 replies; 20+ messages in thread
From: Keith Christian @ 2024-07-12 01:01 UTC (permalink / raw)
To: sam.stearns@dat.com; +Cc: pgsql-admin@lists.postgresql.org; catherine.schulz@dat.com; peter.garza@dat.com; henry.ashu@dat.com
Sam,
I see lots of good info when Googling "oracle to postgres migrationn" in
particular, there exists a tool, Ora2Pg.
---- Keith
On Thu, Jul 11, 2024, 18:02 Sam Stearns <sam.stearns@dat.com> wrote:
> Howdy,
>
> We have a project to migrate our Oracle databases that are hosted on an
> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>
>
> 1. Is there a tool out there that we can use to analyze resource
> sizing on the Appliance that will give resource sizing recommendations for
> the VM?
> 2. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
> Thanks,
>
> Sam
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 01:23 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Sam Stearns <sam.stearns@dat.com>
4 siblings, 2 replies; 20+ messages in thread
From: Ron Johnson @ 2024-07-12 01:23 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
> Howdy,
>
> We have a project to migrate our Oracle databases that are hosted on an
> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>
>
> 1. Is there a tool out there that we can use to analyze resource
> sizing on the Appliance that will give resource sizing recommendations for
> the VM?
>
>
The appliance doesn't tell you how much space your database uses???
Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
would be about the same size (or smaller now, since compression on
dupes-allowed b-tree indices is much better now than in PG 12).
>
> 1. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
>
As Keith said, Google is your friend.
That's how I found ora2pg, which we used in our conversion project (for the
data only; someone had to rewrite all the stored procedures).
If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0)
columns to BIGINT.
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 01:45 Sam Stearns <sam.stearns@dat.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 20+ messages in thread
From: Sam Stearns @ 2024-07-12 01:45 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thanks for all the advice on the conversion stuff!
For the resource sizing I was chasing more CPU and memory analysis then
giving recommendations on right-sizing the VM.
On Fri, Jul 12, 2024 at 10:53 AM Ron Johnson <ronljohnsonjr@gmail.com>
wrote:
> On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
>
>> Howdy,
>>
>> We have a project to migrate our Oracle databases that are hosted on an
>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>
>>
>> 1. Is there a tool out there that we can use to analyze resource
>> sizing on the Appliance that will give resource sizing recommendations for
>> the VM?
>>
>>
> The appliance doesn't tell you how much space your database uses???
>
> Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
> Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
> would be about the same size (or smaller now, since compression on
> dupes-allowed b-tree indices is much better now than in PG 12).
>
>
>>
>> 1. Is there a schema conversion tool or similar out there that we can
>> use to convert Oracle ==> Postgres?
>>
>>
> As Keith said, Google is your friend.
>
> That's how I found ora2pg, which we used in our conversion project (for
> the data only; someone had to rewrite all the stored procedures).
>
> If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0)
> columns to BIGINT.
>
>>
--
*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 02:21 Muhammad Ikram <mmikram@gmail.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
1 sibling, 2 replies; 20+ messages in thread
From: Muhammad Ikram @ 2024-07-12 02:21 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi,
Three tools I know which can help .
Ora2pg : A free tool that helps in migration of schema and data both. Rich
in options and best suits for target vanila PG.
EDB’s Migration toolkit can migrate both schema and dara but for vanila PG
code objects won’t migrate.
Amazon SCT converters schema and Amazon has service to migrate data.
Regards,
Muhammad Ikram
Bitnine Global
On Fri, 12 Jul 2024 at 06:23, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
>
>> Howdy,
>>
>> We have a project to migrate our Oracle databases that are hosted on an
>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>
>>
>> 1. Is there a tool out there that we can use to analyze resource
>> sizing on the Appliance that will give resource sizing recommendations for
>> the VM?
>>
>>
> The appliance doesn't tell you how much space your database uses???
>
> Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
> Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
> would be about the same size (or smaller now, since compression on
> dupes-allowed b-tree indices is much better now than in PG 12).
>
>
>>
>> 1. Is there a schema conversion tool or similar out there that we can
>> use to convert Oracle ==> Postgres?
>>
>>
> As Keith said, Google is your friend.
>
> That's how I found ora2pg, which we used in our conversion project (for
> the data only; someone had to rewrite all the stored procedures).
>
> If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0)
> columns to BIGINT.
>
>>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 02:29 Zaid Shabbir <zaidshabbir@gmail.com>
parent: Muhammad Ikram <mmikram@gmail.com>
1 sibling, 0 replies; 20+ messages in thread
From: Zaid Shabbir @ 2024-07-12 02:29 UTC (permalink / raw)
To: Muhammad Ikram <mmikram@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>; Ron Johnson <ronljohnsonjr@gmail.com>
Hello,
Many free and licence software available for ora to pg migration. If you
are facing difficulties during the migration process by using the free
tools you can consult. Many consultants and volunteers will help you in the
process.
Regards,
Zaid
Bitnine Global
On Fri, 12 Jul 2024 at 7:21 AM, Muhammad Ikram <mmikram@gmail.com> wrote:
> Hi,
>
> Three tools I know which can help .
>
> Ora2pg : A free tool that helps in migration of schema and data both. Rich
> in options and best suits for target vanila PG.
>
> EDB’s Migration toolkit can migrate both schema and dara but for vanila PG
> code objects won’t migrate.
> Amazon SCT converters schema and Amazon has service to migrate data.
>
> Regards,
>
> Muhammad Ikram
> Bitnine Global
>
>
> On Fri, 12 Jul 2024 at 06:23, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
>> On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
>>
>>> Howdy,
>>>
>>> We have a project to migrate our Oracle databases that are hosted on an
>>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>>
>>>
>>> 1. Is there a tool out there that we can use to analyze resource
>>> sizing on the Appliance that will give resource sizing recommendations for
>>> the VM?
>>>
>>>
>> The appliance doesn't tell you how much space your database uses???
>>
>> Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
>> Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
>> would be about the same size (or smaller now, since compression on
>> dupes-allowed b-tree indices is much better now than in PG 12).
>>
>>
>>>
>>> 1. Is there a schema conversion tool or similar out there that we
>>> can use to convert Oracle ==> Postgres?
>>>
>>>
>> As Keith said, Google is your friend.
>>
>> That's how I found ora2pg, which we used in our conversion project (for
>> the data only; someone had to rewrite all the stored procedures).
>>
>> If you use ora2pg, remember to tell it to convert all of the
>> NUMERIC(38,0) columns to BIGINT.
>>
>>>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 04:17 Kashif Zeeshan <kashi.zeeshan@gmail.com>
parent: Sam Stearns <sam.stearns@dat.com>
4 siblings, 1 reply; 20+ messages in thread
From: Kashif Zeeshan @ 2024-07-12 04:17 UTC (permalink / raw)
To: Sam Stearns <sam.stearns@dat.com>; +Cc: pgsql-admin@lists.postgresql.org, Catherine Schulz <catherine.schulz@dat.com>; Peter Garza <peter.garza@dat.com>; Henry Ashu <henry.ashu@dat.com>
Hi Sam
There are alot of open source and proprietary solutions available, but you
should choose between them carefully as cost is not the only factor.\
EDB's MTK (Migration Toolkit) and Migration Portal are solid products for
this purpose.
Regards
Kashif Zeeshan
On Fri, Jul 12, 2024 at 5:02 AM Sam Stearns <sam.stearns@dat.com> wrote:
> Howdy,
>
> We have a project to migrate our Oracle databases that are hosted on an
> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>
>
> 1. Is there a tool out there that we can use to analyze resource
> sizing on the Appliance that will give resource sizing recommendations for
> the VM?
> 2. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
> Thanks,
>
> Sam
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 11:15 Peter Garza <peter.garza@dat.com>
parent: Kashif Zeeshan <kashi.zeeshan@gmail.com>
0 siblings, 1 reply; 20+ messages in thread
From: Peter Garza @ 2024-07-12 11:15 UTC (permalink / raw)
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>; +Cc: Sam Stearns <sam.stearns@dat.com>; pgsql-admin@lists.postgresql.org, Catherine Schulz <catherine.schulz@dat.com>; Henry Ashu <henry.ashu@dat.com>
Peter GarzaPeter Garza 10 hours ago
<https://dat-solutions.slack.com/archives/C07ABNGBS4D/p1720746398149879?thread_ts=1720745054.429439&a...;
Here is a good paper - Please note that EBT Migration Portal goes with the
Postgres Advanced Server.
Thank You
https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-co...
[image: image.png]
On Thu, Jul 11, 2024 at 9:18 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
wrote:
> Hi Sam
>
> There are alot of open source and proprietary solutions available, but you
> should choose between them carefully as cost is not the only factor.\
> EDB's MTK (Migration Toolkit) and Migration Portal are solid products for
> this purpose.
>
> Regards
> Kashif Zeeshan
>
> On Fri, Jul 12, 2024 at 5:02 AM Sam Stearns <sam.stearns@dat.com> wrote:
>
>> Howdy,
>>
>> We have a project to migrate our Oracle databases that are hosted on an
>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>
>>
>> 1. Is there a tool out there that we can use to analyze resource
>> sizing on the Appliance that will give resource sizing recommendations for
>> the VM?
>> 2. Is there a schema conversion tool or similar out there that we can
>> use to convert Oracle ==> Postgres?
>>
>> Thanks,
>>
>> Sam
>>
>> --
>>
>> *Samuel Stearns*
>> Lead Database Administrator
>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>> [image: DAT]
>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>
>
Attachments:
[image/png] image.png (128.7K, ../../CABBmw--qZFBoTJ-tQUg3P3ZyPX+=kRJLTM6AJ3n0eS_wiKGx-Q@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 11:39 Muhammad Waqas <waqas.m@bitnine.net>
parent: Sam Stearns <sam.stearns@dat.com>
4 siblings, 1 reply; 20+ messages in thread
From: Muhammad Waqas @ 2024-07-12 11:39 UTC (permalink / raw)
To: Sam Stearns <sam.stearns@dat.com>; +Cc: pgsql-admin@lists.postgresql.org, Catherine Schulz <catherine.schulz@dat.com>; Peter Garza <peter.garza@dat.com>; Henry Ashu <henry.ashu@dat.com>
ora2pg for object migration
sqllines for data migration
above tools are tested
2024년 7월 12일 (금) 오전 5:02, Sam Stearns <sam.stearns@dat.com>님이 작성:
> Howdy,
>
> We have a project to migrate our Oracle databases that are hosted on an
> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>
>
> 1. Is there a tool out there that we can use to analyze resource
> sizing on the Appliance that will give resource sizing recommendations for
> the VM?
> 2. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
> Thanks,
>
> Sam
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 13:13 ji hwan song <song7357@gmail.com>
parent: Muhammad Waqas <waqas.m@bitnine.net>
0 siblings, 1 reply; 20+ messages in thread
From: ji hwan song @ 2024-07-12 13:13 UTC (permalink / raw)
To: Muhammad Waqas <waqas.m@bitnine.net>; +Cc: Sam Stearns <sam.stearns@dat.com>; pgsql-admin@lists.postgresql.org, Catherine Schulz <catherine.schulz@dat.com>; Peter Garza <peter.garza@dat.com>; Henry Ashu <henry.ashu@dat.com>
저는 한국의 20년차 dba 입니다. 현재 oracle /tibero db , podstgres,/edb/mysql /mariadb
, 서로 migration 할수 있는 java 된 프로그램 만들었습니다.
기능은 source db 와 targetdb 의 스키마 연동 ( table생성 ,pk 와 pk index 자동 생성 기능 ,
source db target db data migration 기능 까지 가능 합니다.
아직까지는 다양한 스키마로 테스트 안되었습니다. 저에게 oracle 11 버전 dump 파일을 보내주시면 테스트 해보고 소스 제공해
드리겠습니다.
2024년 7월 12일 (금) 오후 8:39, Muhammad Waqas <waqas.m@bitnine.net>님이 작성:
> ora2pg for object migration
> sqllines for data migration
>
> above tools are tested
>
> 2024년 7월 12일 (금) 오전 5:02, Sam Stearns <sam.stearns@dat.com>님이 작성:
>
>> Howdy,
>>
>> We have a project to migrate our Oracle databases that are hosted on an
>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>
>>
>> 1. Is there a tool out there that we can use to analyze resource
>> sizing on the Appliance that will give resource sizing recommendations for
>> the VM?
>> 2. Is there a schema conversion tool or similar out there that we can
>> use to convert Oracle ==> Postgres?
>>
>> Thanks,
>>
>> Sam
>>
>> --
>>
>> *Samuel Stearns*
>> Lead Database Administrator
>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>> [image: DAT]
>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 13:15 Avinash Vallarapu <avinash.vallarapu@gmail.com>
parent: ji hwan song <song7357@gmail.com>
0 siblings, 0 replies; 20+ messages in thread
From: Avinash Vallarapu @ 2024-07-12 13:15 UTC (permalink / raw)
To: Muhammad Waqas <waqas.m@bitnine.net>; Sam Stearns <sam.stearns@dat.com>; Catherine Schulz <catherine.schulz@dat.com>; Peter Garza <peter.garza@dat.com>; Henry Ashu <henry.ashu@dat.com>; +Cc: pgsql-admin@lists.postgresql.org
Ora2Pg Support Chatbot and Converter may be of some help too.
https://ora2pgsupport.hexacluster.ai/
On Fri, Jul 12, 2024 at 9:13 AM ji hwan song <song7357@gmail.com> wrote:
> 저는 한국의 20년차 dba 입니다. 현재 oracle /tibero db , podstgres,/edb/mysql
> /mariadb , 서로 migration 할수 있는 java 된 프로그램 만들었습니다.
> 기능은 source db 와 targetdb 의 스키마 연동 ( table생성 ,pk 와 pk index 자동 생성 기능 ,
> source db target db data migration 기능 까지 가능 합니다.
> 아직까지는 다양한 스키마로 테스트 안되었습니다. 저에게 oracle 11 버전 dump 파일을 보내주시면 테스트 해보고 소스 제공해
> 드리겠습니다.
>
> 2024년 7월 12일 (금) 오후 8:39, Muhammad Waqas <waqas.m@bitnine.net>님이 작성:
>
>> ora2pg for object migration
>> sqllines for data migration
>>
>> above tools are tested
>>
>> 2024년 7월 12일 (금) 오전 5:02, Sam Stearns <sam.stearns@dat.com>님이 작성:
>>
>>> Howdy,
>>>
>>> We have a project to migrate our Oracle databases that are hosted on an
>>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>>
>>>
>>> 1. Is there a tool out there that we can use to analyze resource
>>> sizing on the Appliance that will give resource sizing recommendations for
>>> the VM?
>>> 2. Is there a schema conversion tool or similar out there that we
>>> can use to convert Oracle ==> Postgres?
>>>
>>> Thanks,
>>>
>>> Sam
>>>
>>> --
>>>
>>> *Samuel Stearns*
>>> Lead Database Administrator
>>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>>> [image: DAT]
>>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>>
>>
--
Regards,
Avi Vallarapu
CEO
HexaCluster Corp.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-12 13:41 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Sam Stearns <sam.stearns@dat.com>
0 siblings, 1 reply; 20+ messages in thread
From: Ron Johnson @ 2024-07-12 13:41 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
We did the safe thing, and sized the RDS Postgresql the same as the Linux
system running Oracle 12. Turned out to be massively over-sized.
Your mileage will *certainly* vary, though.
PG12 used a lot less CPU and RAM than PG12.
On Thu, Jul 11, 2024 at 9:45 PM Sam Stearns <sam.stearns@dat.com> wrote:
> Thanks for all the advice on the conversion stuff!
>
> For the resource sizing I was chasing more CPU and memory analysis then
> giving recommendations on right-sizing the VM.
>
> On Fri, Jul 12, 2024 at 10:53 AM Ron Johnson <ronljohnsonjr@gmail.com>
> wrote:
>
>> On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
>>
>>> Howdy,
>>>
>>> We have a project to migrate our Oracle databases that are hosted on an
>>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>>
>>>
>>> 1. Is there a tool out there that we can use to analyze resource
>>> sizing on the Appliance that will give resource sizing recommendations for
>>> the VM?
>>>
>>>
>> The appliance doesn't tell you how much space your database uses???
>>
>> Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
>> Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
>> would be about the same size (or smaller now, since compression on
>> dupes-allowed b-tree indices is much better now than in PG 12).
>>
>>
>>>
>>> 1. Is there a schema conversion tool or similar out there that we
>>> can use to convert Oracle ==> Postgres?
>>>
>>>
>> As Keith said, Google is your friend.
>>
>> That's how I found ora2pg, which we used in our conversion project (for
>> the data only; someone had to rewrite all the stored procedures).
>>
>> If you use ora2pg, remember to tell it to convert all of the
>> NUMERIC(38,0) columns to BIGINT.
>>
>>>
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-14 22:44 Sam Stearns <sam.stearns@dat.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 20+ messages in thread
From: Sam Stearns @ 2024-07-14 22:44 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thank you, Ron!
On Fri, Jul 12, 2024 at 11:12 PM Ron Johnson <ronljohnsonjr@gmail.com>
wrote:
> We did the safe thing, and sized the RDS Postgresql the same as the Linux
> system running Oracle 12. Turned out to be massively over-sized.
>
> Your mileage will *certainly* vary, though.
>
> PG12 used a lot less CPU and RAM than PG12.
> On Thu, Jul 11, 2024 at 9:45 PM Sam Stearns <sam.stearns@dat.com> wrote:
>
>> Thanks for all the advice on the conversion stuff!
>>
>> For the resource sizing I was chasing more CPU and memory analysis then
>> giving recommendations on right-sizing the VM.
>>
>> On Fri, Jul 12, 2024 at 10:53 AM Ron Johnson <ronljohnsonjr@gmail.com>
>> wrote:
>>
>>> On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
>>>
>>>> Howdy,
>>>>
>>>> We have a project to migrate our Oracle databases that are hosted on an
>>>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>>>
>>>>
>>>> 1. Is there a tool out there that we can use to analyze resource
>>>> sizing on the Appliance that will give resource sizing recommendations for
>>>> the VM?
>>>>
>>>>
>>> The appliance doesn't tell you how much space your database uses???
>>>
>>> Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
>>> Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
>>> would be about the same size (or smaller now, since compression on
>>> dupes-allowed b-tree indices is much better now than in PG 12).
>>>
>>>
>>>>
>>>> 1. Is there a schema conversion tool or similar out there that we
>>>> can use to convert Oracle ==> Postgres?
>>>>
>>>>
>>> As Keith said, Google is your friend.
>>>
>>> That's how I found ora2pg, which we used in our conversion project (for
>>> the data only; someone had to rewrite all the stored procedures).
>>>
>>> If you use ora2pg, remember to tell it to convert all of the
>>> NUMERIC(38,0) columns to BIGINT.
>>>
>>>>
>>
>> --
>>
>> *Samuel Stearns*
>> Lead Database Administrator
>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>> [image: DAT]
>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>
>
--
*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-22 12:46 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Peter Garza <peter.garza@dat.com>
0 siblings, 1 reply; 20+ messages in thread
From: Ron Johnson @ 2024-07-22 12:46 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
ora2pg certainly migrated all the data objects that we cared about
(including CLOB and XML types). That was 2-3 years ago.
Didn't ask it to migrate plsql.
On Mon, Jul 22, 2024 at 8:38 AM Peter Garza <peter.garza@dat.com> wrote:
>
> Peter GarzaPeter Garza 10 hours ago
> <https://dat-solutions.slack.com/archives/C07ABNGBS4D/p1720746398149879?thread_ts=1720745054.429439&a...;
> Here is a good paper - Please note that EBT Migration Portal goes with
> the Postgres Advanced Server.
> Thank You
>
>
> https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-co...
>
> [image: image.png]
>
> On Thu, Jul 11, 2024 at 9:18 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
> wrote:
>
>> Hi Sam
>>
>> There are alot of open source and proprietary solutions available, but
>> you should choose between them carefully as cost is not the only factor.\
>> EDB's MTK (Migration Toolkit) and Migration Portal are solid products for
>> this purpose.
>>
>> Regards
>> Kashif Zeeshan
>>
>> On Fri, Jul 12, 2024 at 5:02 AM Sam Stearns <sam.stearns@dat.com> wrote:
>>
>>> Howdy,
>>>
>>> We have a project to migrate our Oracle databases that are hosted on an
>>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>>
>>>
>>> 1. Is there a tool out there that we can use to analyze resource
>>> sizing on the Appliance that will give resource sizing recommendations for
>>> the VM?
>>> 2. Is there a schema conversion tool or similar out there that we
>>> can use to convert Oracle ==> Postgres?
>>>
>>> Thanks,
>>>
>>> Sam
>>>
>>> --
>>>
>>> *Samuel Stearns*
>>> Lead Database Administrator
>>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>>> [image: DAT]
>>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>>
>>
Attachments:
[image/png] image.png (128.7K, ../../CANzqJaABFWcdphGXju8N5SHJs2AH10uA_ocpkBXg9YJ5ZZHxHg@mail.gmail.com/3-image.png)
download | view image
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-22 18:51 Muhammad Ikram <mmikram@gmail.com>
parent: Sam Stearns <sam.stearns@dat.com>
4 siblings, 2 replies; 20+ messages in thread
From: Muhammad Ikram @ 2024-07-22 18:51 UTC (permalink / raw)
To: Sam Stearns <sam.stearns@dat.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Sam,
EnterpriseDB Migration Toolkit though won't analyze but can do migration
of both objects and data. Migration Portal from EDB is good for assessing
and migrating Schema. It provides you opportunity to reassess failed
objects after manual repair as well.
You may use the Migration portal for schema objects and then MTK for data
migration.
ora2pg is a free tool and good for both but have not used much.
About Analysis for resources, we have noticed that after migration db takes
much less space as compared to Oracle.
Regards,
Muhammad Ikram
On Fri, Jul 12, 2024 at 5:02 AM Sam Stearns <sam.stearns@dat.com> wrote:
> Howdy,
>
> We have a project to migrate our Oracle databases that are hosted on an
> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>
>
> 1. Is there a tool out there that we can use to analyze resource
> sizing on the Appliance that will give resource sizing recommendations for
> the VM?
> 2. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
> Thanks,
>
> Sam
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>
--
Muhammad Ikram
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-22 19:08 Sam Stearns <sam.stearns@dat.com>
parent: Muhammad Ikram <mmikram@gmail.com>
1 sibling, 0 replies; 20+ messages in thread
From: Sam Stearns @ 2024-07-22 19:08 UTC (permalink / raw)
To: Muhammad Ikram <mmikram@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thank you, Ron and Muhammad!
On Tue, Jul 23, 2024 at 4:21 AM Muhammad Ikram <mmikram@gmail.com> wrote:
> Hi Sam,
>
> EnterpriseDB Migration Toolkit though won't analyze but can do migration
> of both objects and data. Migration Portal from EDB is good for assessing
> and migrating Schema. It provides you opportunity to reassess failed
> objects after manual repair as well.
> You may use the Migration portal for schema objects and then MTK for data
> migration.
>
> ora2pg is a free tool and good for both but have not used much.
>
> About Analysis for resources, we have noticed that after migration db
> takes much less space as compared to Oracle.
>
> Regards,
> Muhammad Ikram
>
>
> On Fri, Jul 12, 2024 at 5:02 AM Sam Stearns <sam.stearns@dat.com> wrote:
>
>> Howdy,
>>
>> We have a project to migrate our Oracle databases that are hosted on an
>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>
>>
>> 1. Is there a tool out there that we can use to analyze resource
>> sizing on the Appliance that will give resource sizing recommendations for
>> the VM?
>> 2. Is there a schema conversion tool or similar out there that we can
>> use to convert Oracle ==> Postgres?
>>
>> Thanks,
>>
>> Sam
>>
>> --
>>
>> *Samuel Stearns*
>> Lead Database Administrator
>> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
>> [image: DAT]
>> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>>
>
>
> --
> Muhammad Ikram
>
>
--
*Samuel Stearns*
Lead Database Administrator
*c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
[image: DAT]
<https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-22 19:13 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Muhammad Ikram <mmikram@gmail.com>
1 sibling, 0 replies; 20+ messages in thread
From: Ron Johnson @ 2024-07-22 19:13 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, Jul 22, 2024 at 2:51 PM Muhammad Ikram <mmikram@gmail.com> wrote:
[snip]
> About Analysis for resources, we have noticed that after migration db
> takes much less space as compared to Oracle.
>
I noticed that, too. Our 8TB CLOB-heavy Oracle database became a 6TB
bytea-heavy PG12 database.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-23 03:25 Muhammad Ikram <mmikram@gmail.com>
parent: Muhammad Ikram <mmikram@gmail.com>
1 sibling, 1 reply; 20+ messages in thread
From: Muhammad Ikram @ 2024-07-23 03:25 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Ron,
An explanation here about what I said above. EDB's Migration toolkit is not
a choice if you want to migrate code objects (Procedures, Packages,
Functions, Triggers etc) to community PostgreSQL. Migration Portal again
assesses and converts for EDB Postgres which is much Oracle compatible.
EDB Migration toolkit can be good for data objects and data transfer to
Community Postgres. If you want to migrate to EDB Postgres (EPAS) then
these tEDB ools are best for migrating code and data objects including data.
For Oracle to Community Postgres *Ora2PG* is good enough
Regards,
Muhammad Ikram
Bitnine.
On Fri, Jul 12, 2024 at 7:21 AM Muhammad Ikram <mmikram@gmail.com> wrote:
> Hi,
>
> Three tools I know which can help .
>
> Ora2pg : A free tool that helps in migration of schema and data both. Rich
> in options and best suits for target vanila PG.
>
> EDB’s Migration toolkit can migrate both schema and dara but for vanila PG
> code objects won’t migrate.
> Amazon SCT converters schema and Amazon has service to migrate data.
>
> Regards,
>
> Muhammad Ikram
> Bitnine Global
>
>
> On Fri, 12 Jul 2024 at 06:23, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
>> On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam.stearns@dat.com> wrote:
>>
>>> Howdy,
>>>
>>> We have a project to migrate our Oracle databases that are hosted on an
>>> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>>>
>>>
>>> 1. Is there a tool out there that we can use to analyze resource
>>> sizing on the Appliance that will give resource sizing recommendations for
>>> the VM?
>>>
>>>
>> The appliance doesn't tell you how much space your database uses???
>>
>> Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
>> Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
>> would be about the same size (or smaller now, since compression on
>> dupes-allowed b-tree indices is much better now than in PG 12).
>>
>>
>>>
>>> 1. Is there a schema conversion tool or similar out there that we
>>> can use to convert Oracle ==> Postgres?
>>>
>>>
>> As Keith said, Google is your friend.
>>
>> That's how I found ora2pg, which we used in our conversion project (for
>> the data only; someone had to rewrite all the stored procedures).
>>
>> If you use ora2pg, remember to tell it to convert all of the
>> NUMERIC(38,0) columns to BIGINT.
>>
>>>
--
Muhammad Ikram
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-23 04:23 Sam Stearns <sam.stearns@dat.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 20+ messages in thread
From: Sam Stearns @ 2024-07-23 04:23 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
--Apple-Mail-FD41D565-00BA-4265-B30E-3B39AE69D320
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Thanks Ron,<div><br></div><div>Any suggesti=
on for plsql?</div><div><br></div><div><div dir=3D"ltr">Sent from my iPhone<=
/div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Jul 22, 2024, at 10:1=
6=E2=80=AFPM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:<br><br></bl=
ockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D=
"ltr"><div><br></div><div>ora2pg certainly migrated all the data objects tha=
t we cared about (including CLOB and XML types). That was 2-3 years ag=
o.</div><div><br></div><div>Didn't ask it to migrate plsql.</div><div><br></=
div><div dir=3D"ltr">On Mon, Jul 22, 2024 at 8:38=E2=80=AFAM Peter Garza <=
;<a href=3D"mailto:peter.garza@dat.com">peter.garza@dat.com</a>> wrote:<b=
r></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><span style=3D"box-sizing:inherit;color:rgb(29,28,29=
);word-break:break-word;font-family:Slack-Lato,Slack-Fractions,appleLogo,san=
s-serif;font-size:15px;font-variant-ligatures:common-ligatures;background-co=
lor:rgb(248,248,248)"><span role=3D"presentation" style=3D"box-sizing:inheri=
t;width:fit-content;height:fit-content;display:inline-flex"><button type=3D"=
button" style=3D"box-sizing:inherit;background-image:initial;background-posi=
tion:0px 0px;background-size:initial;background-repeat:initial;background-or=
igin:initial;background-clip:initial;border-width:0px;border-style:initial;b=
order-color:initial;padding:0px;font:inherit;overflow:initial;text-align:ini=
tial;vertical-align:baseline;margin:0px"><br>Peter Garza</button></span><spa=
n id=3D"m_3383958532497247761gmail-secondary-C07ABNGBS4D-1720746398.149879-s=
ender" aria-hidden=3D"true" style=3D"box-sizing:inherit;border:0px;width:1px=
;height:1px;padding:0px;overflow:hidden">Peter Garza</span></span><span styl=
e=3D"color:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,sa=
ns-serif;font-size:15px;font-variant-ligatures:common-ligatures;background-c=
olor:rgb(248,248,248)"> </span><a aria-label=3D"Yesterday at 6:06=
:38 PM" href=3D"https://dat-solutions.slack.com/archives/C07ABNGBS4D/p172074=
6398149879?thread_ts=3D1720745054.429439&cid=3DC07ABNGBS4D" style=3D"box=
-sizing:inherit;text-decoration-line:none;font-size:12px;font-family:Slack-L=
ato,Slack-Fractions,appleLogo,sans-serif;font-variant-ligatures:common-ligat=
ures;background-color:rgb(248,248,248)" target=3D"_blank"><span style=3D"box=
-sizing:inherit">10 hours ago</span></a><br style=3D"box-sizing:inherit;colo=
r:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,sans-serif;=
font-size:15px;font-variant-ligatures:common-ligatures;background-color:rgb(=
248,248,248)"><div style=3D"box-sizing:inherit;max-width:none;margin-bottom:=
4px;color:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,san=
s-serif;font-size:15px;font-variant-ligatures:common-ligatures;background-co=
lor:rgb(248,248,248)"><div style=3D"box-sizing:inherit;max-width:none"><div s=
tyle=3D"box-sizing:inherit;width:664px"><div style=3D"box-sizing:inherit;dis=
play:flex"><div dir=3D"auto" style=3D"box-sizing:inherit;width:664px;overflo=
w-y:hidden;line-height:1.46668"><div style=3D"box-sizing:inherit">Here is a g=
ood paper - Please note that EBT Migration Portal goes with the Postgr=
es Advanced Server. <br>Thank You<br><br style=3D"box-sizing:inherit"><=
a href=3D"https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresq=
l-migration-guide-tutorial-move-convert-database-oracle-alternative" rel=3D"=
noopener noreferrer" style=3D"box-sizing:inherit;text-decoration-line:none" t=
arget=3D"_blank">https://www.enterprisedb.com/blog/the-complete-oracle-to-po=
stgresql-migration-guide-tutorial-move-convert-database-oracle-alternative</=
a><br><br><div><image.png></div><br></div></div></div></div></div></di=
v></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Thu, Jul 11, 2024 at 9:18=E2=80=AFPM Kashif Zeeshan <<a href=3D"mailt=
o:kashi.zeeshan@gmail.com" target=3D"_blank">kashi.zeeshan@gmail.com</a>>=
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"ltr">Hi Sam<div><br></div><div>There are alot of open source and proprietar=
y solutions available, but you should choose between them carefully&nbs=
p;as cost is not the only factor.\</div><div>EDB's MTK (Migration Toolkit) a=
nd Migration Portal are solid products for this purpose.</div><div><br></div=
><div>Regards</div><div>Kashif Zeeshan</div></div><br><div class=3D"gmail_qu=
ote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 12, 2024 at 5:02=E2=80=
=AFAM Sam Stearns <<a href=3D"mailto:sam.stearns@dat.com" target=3D"_blan=
k">sam.stearns@dat.com</a>> wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div dir=3D"ltr">Howdy,<div><br></div><div>We have a pro=
ject to migrate our Oracle databases that are hosted on an Oracle Database A=
ppliance to Postgres hosted on a Linux VM. Questions:</div><div><br></=
div><div><ol><li>Is there a tool out there that we can use to analyze resour=
ce sizing on the Appliance that will give resource sizing recommendations fo=
r the VM?</li><li>Is there a schema conversion tool or similar out there tha=
t we can use to convert Oracle =3D=3D> Postgres?</li></ol><div>Thanks,</d=
iv><div><br></div><div>Sam</div><div><br></div><span class=3D"gmail_signatur=
e_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D=
"ltr"><p style=3D"color:rgb(0,0,0);font-family:Gotham,"Helvetica Neue&q=
uot;,Helvetica,Arial,sans-serif;font-size:0.8rem;line-height:1.2rem"><strong=
style=3D"font-size:0.9rem;color:rgb(51,51,51)">Samuel Stearns</strong><br><=
span style=3D"color:rgb(102,102,102)">Lead Database Administrator<br><strong=
>c:</strong> 971 762 6879 <span style=3D"color:rgb(147,149,152)">|=
</span> <strong>o:</strong> 503 672 5115 <span style=3D"color=
:rgb(147,149,152)">|</span> DAT.com</span></p><div style=3D"color:rgb(0=
,0,0);font-family:"Times New Roman";font-size:medium"><a href=3D"h=
ttps://www.dat.com/?utm_medium=3Demail&utm_source=3DDAT_email_signature_=
link" target=3D"_blank"><img src=3D"https://www.dat.com/wp-content/uploads/m=
edia/images/global/emails/signature2/dat_126.png" alt=3D"DAT" width=3D"126" h=
eight=3D"54" data-unique-identifier=3D""></a></div></div></div></div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div></div>
</div></blockquote></div></body></html>=
--Apple-Mail-FD41D565-00BA-4265-B30E-3B39AE69D320--
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: Oracle to Postgres
@ 2024-07-23 04:26 Sam Stearns <sam.stearns@dat.com>
parent: Muhammad Ikram <mmikram@gmail.com>
0 siblings, 0 replies; 20+ messages in thread
From: Sam Stearns @ 2024-07-23 04:26 UTC (permalink / raw)
To: Muhammad Ikram <mmikram@gmail.com>; +Cc: Ron Johnson <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
--Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Thanks, Muhammad!<div><br id=3D"lineBreakAt=
BeginningOfSignature"><div dir=3D"ltr">Sent from my iPhone</div><div dir=3D"=
ltr"><br><blockquote type=3D"cite">On Jul 23, 2024, at 12:55=E2=80=AFPM, Muh=
ammad Ikram <mmikram@gmail.com> wrote:<br><br></blockquote></div><bloc=
kquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr">Hi Ron,<div>=
<br></div><div>An explanation here about what I said above. EDB's Migration t=
oolkit is not a choice if you want to migrate code objects (Procedures, Pack=
ages, Functions, Triggers etc) to community PostgreSQL. Migration Portal aga=
in assesses and converts for EDB Postgres which is much Oracle compatible.</=
div><div>EDB Migration toolkit can be good for data objects and data transfe=
r to Community Postgres. If you want to migrate to EDB Postgres (EPAS) then t=
hese tEDB ools are best for migrating code and data objects including data.<=
/div><div><br></div><div>For Oracle to Community Postgres <b>Ora2PG</b> is g=
ood enough</div><div><br></div><div>Regards,</div><div>Muhammad Ikram</div><=
div>Bitnine.</div><div><br></div></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 12, 2024 at 7:21=E2=80=AFAM Muha=
mmad Ikram <<a href=3D"mailto:mmikram@gmail.com">mmikram@gmail.com</a>>=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"auto">Hi,</div><div dir=3D"auto"><br></div><div dir=3D"auto">Three tools I k=
now which can help .</div><div dir=3D"auto"><br></div><div dir=3D"auto">Ora2=
pg : A free tool that helps in migration of schema and data both. Rich in op=
tions and best suits for target vanila PG. </div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">EDB=E2=80=99s Migration toolkit can migrate both sch=
ema and dara but for vanila PG code objects won=E2=80=99t migrate. </di=
v><div dir=3D"auto">Amazon SCT converters schema and Amazon has service to m=
igrate data. </div><div dir=3D"auto"><br></div><div dir=3D"auto">Regard=
s,</div><div dir=3D"auto"><br clear=3D"all"><div dir=3D"auto"><div dir=3D"lt=
r" class=3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"auto">Muhammad Ikr=
am<br>Bitnine Global</div></div></div></div></div><div><br></div><div><br><d=
iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 12 Ju=
l 2024 at 06:23, Ron Johnson <<a href=3D"mailto:ronljohnsonjr@gmail.com" t=
arget=3D"_blank">ronljohnsonjr@gmail.com</a>> wrote:<br></div><blockquote=
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On T=
hu, Jul 11, 2024 at 8:02=E2=80=AFPM Sam Stearns <<a href=3D"mailto:sam.st=
earns@dat.com" target=3D"_blank">sam.stearns@dat.com</a>> wrote:<br></div=
><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div dir=3D"ltr">Howdy,<div><br></div><div>We have a project to migrate our=
Oracle databases that are hosted on an Oracle Database Appliance to Postgre=
s hosted on a Linux VM. Questions:</div><div><br></div><div><ol><li>Is=
there a tool out there that we can use to analyze resource sizing on the Ap=
pliance that will give resource sizing recommendations for the VM?</li></ol>=
</div></div></blockquote><div><br></div><div>The appliance doesn't tell you h=
ow much space your database uses???</div><div><br></div><div>Anyway, we conv=
erted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS Postgresql 12; the=
resulting db was about 6TB. I'm sure that vanilla PG would be about t=
he same size (or smaller now, since compression on dupes-allowed b-tree=
indices is much better now than in PG 12).</div><div> </div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div><ol><li>Is ther=
e a schema conversion tool or similar out there that we can use to convert O=
racle =3D=3D> Postgres?</li></ol></div></div></blockquote><div><br></div>=
<div>As Keith said, Google is your friend.</div><div><br></div><div>That's h=
ow I found ora2pg, which we used in our conversion project (for the data onl=
y; someone had to rewrite all the stored procedures).</div><div><br></div><d=
iv>If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0=
) columns to BIGINT.</div><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><=
div dir=3D"ltr"><div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"=
ltr"></div></div></div></div>
</blockquote></div></div>
</blockquote></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_sig=
nature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div=
dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>
</div></blockquote></div></body></html>=
--Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623--
^ permalink raw reply [nested|flat] 20+ messages in thread
end of thread, other threads:[~2024-07-23 04:26 UTC | newest]
Thread overview: 20+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-12 00:02 Oracle to Postgres Sam Stearns <sam.stearns@dat.com>
2024-07-12 01:01 ` Keith Christian <keith1christian@gmail.com>
2024-07-12 01:23 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-07-12 01:45 ` Sam Stearns <sam.stearns@dat.com>
2024-07-12 13:41 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-07-14 22:44 ` Sam Stearns <sam.stearns@dat.com>
2024-07-12 02:21 ` Muhammad Ikram <mmikram@gmail.com>
2024-07-12 02:29 ` Zaid Shabbir <zaidshabbir@gmail.com>
2024-07-23 03:25 ` Muhammad Ikram <mmikram@gmail.com>
2024-07-23 04:26 ` Sam Stearns <sam.stearns@dat.com>
2024-07-12 04:17 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-07-12 11:15 ` Peter Garza <peter.garza@dat.com>
2024-07-22 12:46 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-07-23 04:23 ` Sam Stearns <sam.stearns@dat.com>
2024-07-12 11:39 ` Muhammad Waqas <waqas.m@bitnine.net>
2024-07-12 13:13 ` ji hwan song <song7357@gmail.com>
2024-07-12 13:15 ` Avinash Vallarapu <avinash.vallarapu@gmail.com>
2024-07-22 18:51 ` Muhammad Ikram <mmikram@gmail.com>
2024-07-22 19:08 ` Sam Stearns <sam.stearns@dat.com>
2024-07-22 19:13 ` Ron Johnson <ronljohnsonjr@gmail.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