Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sW76h-00DJ1P-FH for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jul 2024 04:26:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sW76f-009sgJ-Jv for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jul 2024 04:26:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sW76f-009ses-3h for pgsql-admin@lists.postgresql.org; Tue, 23 Jul 2024 04:26:33 +0000 Received: from mx0a-0039f802.pphosted.com ([205.220.164.45]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sW76c-000ybv-8n for pgsql-admin@lists.postgresql.org; Tue, 23 Jul 2024 04:26:31 +0000 Received: from pps.filterd (m0209981.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 46MKp1NU030164 for ; Mon, 22 Jul 2024 21:26:29 -0700 Received: from mail-pf1-f200.google.com (mail-pf1-f200.google.com [209.85.210.200]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 40ganvjpd6-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Mon, 22 Jul 2024 21:26:29 -0700 (PDT) Received: by mail-pf1-f200.google.com with SMTP id d2e1a72fcca58-70d1a9bad5dso2611643b3a.0 for ; Mon, 22 Jul 2024 21:26:29 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721708788; x=1722313588; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=YdIHcRyZYyB0VgWGhRpqCbbJrB4azC/J78D8RBzdmmo=; b=bz5U8aywFS6nTv5/wgOaehYqaw2P44hvJYwR8W06r0dvlFb/5GnH/Vqgs8NdO72YxK lTV4+i7R/14C/emgdl3DhMDMgGrnMihouOHaN2/Us6+csCd4KzEtmrPdIhP0wCk2f8CG LDKFUmaPjPkaOpfqqWmROmzjZe5rmxqp78saqtWub3kJUOl56ns8NoiGm3+yAuNcNenV PnUG/2seDbC5n2JETwsbEBYig+1426LpljaE9UF6fvd+ll0TqNLAiEsedKVPCaDlB/Ls snfQ+5SH4R71D7ce0oCUAleAxviSF52MiyML3nbOE1F7SFSV3u0q0alBMz4zZLmfWEs7 eADw== X-Forwarded-Encrypted: i=1; AJvYcCUCKM1xTziHG6XBqsYtNQzOqavrl28WtVVQPr4+6vmBuO9FpaV7iUM9NuTCxVbXNJdYbEuGU+gGBsoYdpVVBFg5inJ3Ci20vO8ZU37Yau31rw== X-Gm-Message-State: AOJu0YyuLFJRqF/cwPTZ5tFkqchF+G1079WqzjTREq/SU7w2alVK/Kh/ EcfDd2rdkjkG1g2kcA5+mNt3rgwXe8QF8cNGAqEDwN5pXJRYk7BzCcI4G1l67zX4TvJ1n8l9ssw kPjmcO2Lyw/LLpf41k+q0OllvTq5cCVNIvb+aOby0GjRYRAHXndMenFMn0ZaIjcudMAthYVIXnt OuzAIuRxQ6Ev5WuZIu X-Received: by 2002:a05:6a00:3cc9:b0:70d:3420:9314 with SMTP id d2e1a72fcca58-70d3a89d733mr2529913b3a.12.1721708788332; Mon, 22 Jul 2024 21:26:28 -0700 (PDT) X-Google-Smtp-Source: AGHT+IGgODUMNTbup+xuujj55RPUYbfTS0sP6rzBs/NzuYtlDKQjVpDtIhmNIxsxLDld8cKkljbNhA== X-Received: by 2002:a05:6a00:3cc9:b0:70d:3420:9314 with SMTP id d2e1a72fcca58-70d3a89d733mr2529885b3a.12.1721708787685; Mon, 22 Jul 2024 21:26:27 -0700 (PDT) Received: from smtpclient.apple (pa49-178-122-58.pa.nsw.optusnet.com.au. [49.178.122.58]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-70d1dbfe395sm3252151b3a.218.2024.07.22.21.26.26 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 22 Jul 2024 21:26:26 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623 Content-Transfer-Encoding: 7bit From: Sam Stearns Mime-Version: 1.0 (1.0) Subject: Re: Oracle to Postgres Date: Tue, 23 Jul 2024 13:56:14 +0930 Message-Id: <41F9BECC-15C9-4409-8DD3-36D1F06EF9A8@dat.com> References: Cc: Ron Johnson , Pgsql-admin In-Reply-To: To: Muhammad Ikram X-Mailer: iPhone Mail (21F90) X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16 definitions=2024-07-22_18,2024-07-23_01,2024-05-17_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks, Muhammad!

Sent from my iPhone

On Jul 23, 2024, at 12:55=E2=80=AFPM, Muh= ammad Ikram <mmikram@gmail.com> wrote:

=EF=BB=BF
Hi Ron,
=
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.
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>

For Oracle to Community Postgres Ora2PG is g= ood enough

Regards,
Muhammad Ikram
<= div>Bitnine.


On Fri, Jul 12, 2024 at 7:21=E2=80=AFAM Muha= mmad Ikram <mmikram@gmail.com>= ; wrote:
Hi,

Three tools I k= now which can help .

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. 

=
EDB=E2=80=99s Migration toolkit can migrate both sch= ema and dara but for vanila PG code objects won=E2=80=99t migrate. 
Amazon SCT converters schema and Amazon has service to m= igrate data. 

Regard= s,

Muhammad Ikr= am
Bitnine Global


On Fri, 12 Ju= l 2024 at 06:23, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On T= hu, Jul 11, 2024 at 8:02=E2=80=AFPM 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 Postgre= s hosted on a Linux VM.  Questions:

  1. 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?
=

The appliance doesn't tell you h= ow much space your database uses???

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).
 
  1. Is ther= e a schema conversion tool or similar out there that we can use to convert O= racle =3D=3D> Postgres?

=
As Keith said, Google is your friend.

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

If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0= ) columns to BIGINT.
<= div dir=3D"ltr">


--
Muhammad Ikram

= --Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623--