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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1n80tT-0008Ex-V9
	for pgsql-admin@arkaria.postgresql.org; Thu, 13 Jan 2022 14:15:59 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1n80tS-0005p9-JB
	for pgsql-admin@arkaria.postgresql.org; Thu, 13 Jan 2022 14:15:58 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <rjuju123@gmail.com>)
	id 1n80r5-00064b-S7
	for pgsql-admin@lists.postgresql.org; Thu, 13 Jan 2022 14:13:32 +0000
Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <rjuju123@gmail.com>)
	id 1n80r3-0004FV-5O
	for pgsql-admin@lists.postgresql.org; Thu, 13 Jan 2022 14:13:31 +0000
Received: by mail-pj1-x102f.google.com with SMTP id
 59-20020a17090a09c100b001b34a13745eso18990868pjo.5
        for <pgsql-admin@lists.postgresql.org>;
 Thu, 13 Jan 2022 06:13:29 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=date:from:to:cc:subject:message-id:references:mime-version
         :content-disposition:in-reply-to;
        bh=gwjz7p/IoHcKynviLL1KMExfw4bwDxtHcs+B4TpVjoY=;
        b=qezQHwmYFoIBLSi1fs1MvK13XbA3eYTMh5gRmIhIbieiGKMbB1s2dWJzDIxIzG+F0O
         f3LyA5M7FcYChUsg96vVoz6bSSC9yPXgqDS2Xkw47P4IJwFbDvPvKXNNylAOOXYE6G1E
         Urq7m4c2kIBybX4usrbkGcTH+I6NaJhAqlpTcDFBNIWy439YuxLFfYzFK07q26zpzZaK
         ZAt/qB0DSNXAyhRZFWEcigKNzCwtVIBXmzv7ikG5JZ01ArwQgNlWHVSvubmHoTjzGSMp
         EWyZyneomZK4KnoB538ikE7Q0jgZUjjqOp353uBNOVbGQn3V8/QO/k3Zo8O0Wk5ivncj
         WL6A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:references
         :mime-version:content-disposition:in-reply-to;
        bh=gwjz7p/IoHcKynviLL1KMExfw4bwDxtHcs+B4TpVjoY=;
        b=7ufaCTP0QjenAXLCxZaQUJozBIhd3vu8rJHkSQGQWjOzoCahSHWfwiz4llh7TcvMwq
         6hlK7uP1MuFpJ1TRUU0t2xxool5fM3J0/6oI2oAUaV2kMEW2WJk7SFpDkjNBRAeJOSFl
         YTx2c2e/Pvxhyy9KoKkXdYh2nWaAGJ0U0Iw+PAktg6u8zYlFc8LaRzh9RJUpzaBOdhn3
         iXvFTjhgZoxIm2LAEP6r7IUXB3075b5DHe6+3XQ1ZqxuaZwaC4ofj5ZRx9dGmedfsasJ
         mim/ClGyJuAva7zXxr4OrJZ9tX4GBFTo2Q7VZlDL8oCh9jZKLeKq8idrt62rGkxP6D6D
         ozCw==
X-Gm-Message-State: AOAM5317w6fTeTxOGE4cTYpdo4go2v02S3fzXqQF5wEmbMm/jBzREm5t
	n/CQ9//9IE3qQ0JRRCBrQYM=
X-Google-Smtp-Source: 
 ABdhPJz0tTLBPrckwEl33FFtJo7reCHaC7hlztUiOOz5YhvxSd6EbEzBzVig2JguVkWFoGxkKdDjew==
X-Received: by 2002:a17:902:c086:b0:14a:6828:388d with SMTP id
 j6-20020a170902c08600b0014a6828388dmr4767498pld.17.1642083207180;
        Thu, 13 Jan 2022 06:13:27 -0800 (PST)
Received: from jrouhaud (1-171-185-43.dynamic-ip.hinet.net. [1.171.185.43])
        by smtp.gmail.com with ESMTPSA id
 z24sm8807797pjq.17.2022.01.13.06.13.25
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Thu, 13 Jan 2022 06:13:26 -0800 (PST)
Date: Thu, 13 Jan 2022 22:13:21 +0800
From: Julien Rouhaud <rjuju123@gmail.com>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: Alicja Kucharczyk <zaledwie10minut@gmail.com>,
	pgsql-admin@lists.postgresql.org
Subject: Re: New Oracle system in our house, migration chances
Message-ID: <20220113141321.qdas6evcuc5vvfvp@jrouhaud>
References: <d57a8b83-9ea4-97e7-4b72-720932d40fc1@matrix.gatewaynet.com>
 <CAM=sWa6ydVoznn0EOpy1EhYQAuNgVf36gbUgHk9vijLxoTnOWQ@mail.gmail.com>
 <5387d1e8-a7d4-f568-fef1-30489fe93bba@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <5387d1e8-a7d4-f568-fef1-30489fe93bba@matrix.gatewaynet.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/20220113141321.qdas6evcuc5vvfvp%40jrouhaud>
Precedence: bulk

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