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 1sW74I-00DIrM-0P for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jul 2024 04:24:05 +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 1sW74F-009olT-VO for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jul 2024 04:24:04 +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 1sW74F-009olK-Fe for pgsql-admin@lists.postgresql.org; Tue, 23 Jul 2024 04:24:04 +0000 Received: from mx0b-0039f802.pphosted.com ([205.220.176.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 1sW748-000ybA-Ev for pgsql-admin@lists.postgresql.org; Tue, 23 Jul 2024 04:24:02 +0000 Received: from pps.filterd (m0209982.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 46ML3glN002229 for ; Mon, 22 Jul 2024 21:23:55 -0700 Received: from mail-pg1-f198.google.com (mail-pg1-f198.google.com [209.85.215.198]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 40gbbyasdy-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Mon, 22 Jul 2024 21:23:55 -0700 (PDT) Received: by mail-pg1-f198.google.com with SMTP id 41be03b00d2f7-6c8f99fef10so261138a12.3 for ; Mon, 22 Jul 2024 21:23:54 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721708633; x=1722313433; 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=soZMjb+1H5s9CwaJU1ndlh4MoIqG/HxbSEH2nuWc0tE=; b=D2XcqlKrGuYSBvcDJ5g3s+/8Kgi32nKyWy1WQRn4cK8IMLF1BkD1vXJSwnxU1mSDEV 5cqTl8B65XRqCecp44nYOLmqs+WzqQ1S1ujYDgE5XsRxk2w2dHtfRPGCZpRzHnUqMqzj Xee8sZ+mxAXDY4bA6Nz42VcEdXwSYzfEw+zICZ+3Fe+K01N083BNuQ00RkvumKhwdsL9 FgInDERXQPyk7MjuaBA+LNp+0VUASUknlUTXg9b8zL/gDbh1qzeQ0sKlig9/FGAwBD6G MGF/d57/37PuotDbVEldrUCzvy5lqVcwnC+307LD89Wd4cA92/PKjwITtlgfc0PM9pui j72A== X-Gm-Message-State: AOJu0YympnL/80HkalQuBKkw17r6BWH4fKbB9Ca8TG+kB/V+vpalL+xT CRa02vCV/FZ1cvVXdsk3FevNRpyjP6L7PKFAbyXGpXLpn+FSiNb78o71FSzCa+EycuVPn2lfM54 sE3OeBB2apY3cJdfWJeKqVem50HAmEj2pzoqedxl7TLvzyCycVaSwLyK9+I/fGc1Tj8mEwG51Sa PZjQqJqincPR1yED45+ZHQ3aMgko8= X-Received: by 2002:a05:6a21:c8a:b0:1c3:ce0f:bfb2 with SMTP id adf61e73a8af0-1c4285d55a7mr12025981637.23.1721708633483; Mon, 22 Jul 2024 21:23:53 -0700 (PDT) X-Google-Smtp-Source: AGHT+IFVEE61P/ityh6IANQVeoWimX7ls/lri2uyvnh8aHzlLjgm56Iv2YHyM55tWMqOJe+70LCm4A== X-Received: by 2002:a05:6a21:c8a:b0:1c3:ce0f:bfb2 with SMTP id adf61e73a8af0-1c4285d55a7mr12025953637.23.1721708632692; Mon, 22 Jul 2024 21:23:52 -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 98e67ed59e1d1-2cb772c25ffsm9227419a91.3.2024.07.22.21.23.51 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 22 Jul 2024 21:23:52 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-FD41D565-00BA-4265-B30E-3B39AE69D320 Content-Transfer-Encoding: 7bit From: Sam Stearns Mime-Version: 1.0 (1.0) Subject: Re: Oracle to Postgres Date: Tue, 23 Jul 2024 13:53:39 +0930 Message-Id: References: Cc: Pgsql-admin In-Reply-To: To: Ron Johnson 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-FD41D565-00BA-4265-B30E-3B39AE69D320 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks Ron,

Any suggesti= on for plsql?

Sent from my iPhone<= /div>

On Jul 22, 2024, at 10:1= 6=E2=80=AFPM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

=EF=BB=BF

ora2pg certainly migrated all the data objects tha= t we cared about (including CLOB and XML types).  That was 2-3 years ag= o.

Didn't ask it to migrate plsql.

On Mon, Jul 22, 2024 at 8:38=E2=80=AFAM Peter Garza <= ;peter.garza@dat.com> wrote:
Peter Garza  10 hours ago
Here is a g= ood paper  - Please note that EBT Migration Portal goes with the Postgr= es Advanced Server. 
Thank You

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

<image.png>


On Thu, Jul 11, 2024 at 9:18=E2=80=AFPM Kashif Zeeshan <kashi.zeeshan@gmail.com>= wrote:
Hi Sam

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.\
EDB's MTK (Migration Toolkit) a= nd Migration Portal are solid products for this purpose.

Regards
Kashif Zeeshan

On Fri, Jul 12, 2024 at 5:02=E2=80= =AFAM Sam Stearns <sam.stearns@dat.com> wrote:
Howdy,

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:

  1. 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?
  2. Is there a schema conversion tool or similar out there tha= t we can use to convert Oracle =3D=3D> Postgres?
Thanks,

Sam

--

Samuel Stearns
<= span style=3D"color:rgb(102,102,102)">Lead Database Administrator
c: 971 762 6879 |=  o: 503 672 5115 | DAT.com

3D"DAT"
= --Apple-Mail-FD41D565-00BA-4265-B30E-3B39AE69D320--