Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paG16-0006uG-87 for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 13:09:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paG15-0002dN-3F for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 13:09:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paG14-0002dE-IX for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 13:09:06 +0000 Received: from mail-pj1-x1032.google.com ([2607:f8b0:4864:20::1032]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1paG11-0005Zy-6K for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 13:09:05 +0000 Received: by mail-pj1-x1032.google.com with SMTP id me6-20020a17090b17c600b0023816b0c7ceso6065104pjb.2 for ; Thu, 09 Mar 2023 05:09:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paslists-com.20210112.gappssmtp.com; s=20210112; t=1678367342; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=SHitZXDvjQD7K4MpbGIUUWaRTaBrU5+VW0TL8aiuB2M=; b=KIeaO6iLLFiqJXzDxmCtbrDqJdpJbV9hdqi3KdTqynHkO07NNmFGMHNYUNNQHQjj5l phiHhlEpXU8RpplXyDROWnA+No7mXDpIFNQjomj3fkHpFJyoEbseYyjg6MPofV9T0bFr JGdyah/9HPgMRQLb6Ot/Q9KcV+14eDK0/3+d8MmJgEqk/BGd+I2JN86hCHVGGZPekCEY CmWcoHVrlYYKmY5scy4ghiH52MlcNI0KNm5RgSpkh7Cgge0Wz5+znqaYnF9Rfv1HqCX3 nHQPDdMR6/cfcqP5KA308MnrvP+ZQe/sAzPmMjMY8JXPmvIpwYuZenmMy0py1PVJ/+hI +V0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678367342; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=SHitZXDvjQD7K4MpbGIUUWaRTaBrU5+VW0TL8aiuB2M=; b=z+YM/GbqZN4PSIJRjDWIUfwqTMg4BfSou0i8BSP0x0mSIUDwHeYWC4dNf4k4PcjdYf 6oMzvqmplCC95dOn7+F3LdQkIXrTiSh0XzSW6zhEd2GcQLq/A4l0VRzzMqFIv26g28t6 wuMDeqArVGClZxyNGL+S0hEz5BiYv7LiPpHagbb3y6i93tqdaX8EwDJick01iWU88cgN kXG03XhDIXTyfAI3cTTXcIrRjftggAcfeayXL9u6o8/3fxznX34X2avAtg5KldqUohTe UqaoH4bh5QpvIlDApxo3r2mISD6sbRIWSXuxrQR5ufjIfWUVC4BY56FUgR52clll5PpY QnGA== X-Gm-Message-State: AO0yUKVi05HoQLQKuZdvjKugUWqgJ7zTWp0iRN//BoSVzdzKadeLUD47 w2JmXzMRTK3JqYTIghmTpdPJRvXNFWyqv2v0L5uCusCtYMxPIudY X-Google-Smtp-Source: AK7set9hy9gH4w+pVPE24VI1BY5TX1QgQN/PU+Dl/orDyQ37T1RF6WMVwWZcKBWjyfmMyYhtzCX0jfLv1aTJls3VJ5M= X-Received: by 2002:a17:90a:f98f:b0:231:1dab:f8e with SMTP id cq15-20020a17090af98f00b002311dab0f8emr8056122pjb.9.1678367341569; Thu, 09 Mar 2023 05:09:01 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Eric Raskin Date: Thu, 9 Mar 2023 08:08:35 -0500 Message-ID: Subject: Re: postgresql to Oracle database migration To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000327f8e05f67759f9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000327f8e05f67759f9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Look into ora2pg https://ora2pg.darold.net/. I used it successfully years ago, and it has been enhanced since. We migrated from a local Oracle database to Google Cloud SQL PostgreSQL. There are differences that you will have to repair manually, but the ora2pg website documents many of them. There is also orafce https://github.com/orafce/orafce which contains things like Oracle compatible date routines. I chose to fix the code rather than use it as I wanted to remove all Oracle dependencies as much as possible, but it does work. Good luck. Eric On Thu, Mar 9, 2023 at 4:48=E2=80=AFAM Holger Jakobs wr= ote: > > Am 09.03.23 um 10:46 schrieb Renjith Gk: > > Hi, > > > > Can anyone confirm any online tool or best practice to migrate > > postgresql queries to Oracle, there are few syntax differences > > compared from postgresql to Oracle > > > > Best regards, > > Renjith > > There is no easy solution because Postgres' SQL dialect is a lot richer > than Oracle's. > > Most trivial queries will work immediately. > > Kind regards, > > Holger > > > -- > Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 > > --=20 ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ------------------------------------------------------------ Eric H. Raskin 914-765-0500 x120 or *315-338-4461 (direct)* Professional Advertising Systems Inc. fax: 914-765-0500 or *315-338-4461 (direct)* 3 Morgan Drive #310 eraskin@paslists.com Mt Kisco, NY 10549 http://www.paslists.com --000000000000327f8e05f67759f9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Look into ora2pg=C2=A0https://ora2pg.darold.net/.=C2=A0 I used it successfully=C2=A0years = ago, and it has been enhanced since.=C2=A0 We migrated from a local Oracle = database to Google Cloud SQL PostgreSQL.=C2=A0 There are differences that y= ou will have to repair manually, but the ora2pg website documents many of t= hem.=C2=A0 There is also orafce https://github.com/orafce/orafce=C2=A0which contains things like Orac= le compatible=C2=A0date routines.=C2=A0 I chose to fix the code rather than= use it as I wanted to remove all Oracle dependencies as much as possible, = but it does work.

Good luck.

= =C2=A0 =C2=A0Eric

On Thu, Mar 9, 2023 at 4:48=E2=80=AFAM Holger Jakobs= <holger@jakobs.com> wrote:<= br>

Am 09.03.23 um 10:46 schrieb Renjith Gk:
> Hi,
>
> Can anyone confirm any online tool or best practice to migrate
> postgresql queries to Oracle, there are few syntax differences
> compared from postgresql to Oracle
>
> Best regards,
> Renjith

There is no easy solution because Postgres' SQL dialect is a lot richer=
than Oracle's.

Most trivial queries will work immediately.

Kind regards,

Holger


--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012



--

---------------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= ---------------------

Eric H. Raskin =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0914-765-0500 x120 or= =C2=A0315-338-4461 (direct)

Professional Adver= tising Systems Inc.=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0fax: 914-765-0500 or 315-338-44= 61 (direct)

3 Morgan Drive #310=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0eras= kin@paslists.com

Mt Kisco, NY 10549=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0http://www.paslists.com


= --000000000000327f8e05f67759f9--