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.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1vQ01D-005Bja-1R
	for pgsql-admin@arkaria.postgresql.org;
	Mon, 01 Dec 2025 09:16:27 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1vQ01B-001g3y-2V
	for pgsql-admin@arkaria.postgresql.org;
	Mon, 01 Dec 2025 09:16:26 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1vQ01B-001g3q-1J
	for pgsql-admin@lists.postgresql.org;
	Mon, 01 Dec 2025 09:16:25 +0000
Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1vQ019-002UH8-38
	for pgsql-admin@lists.postgresql.org;
	Mon, 01 Dec 2025 09:16:25 +0000
Received: by mail-ej1-x62a.google.com with SMTP id
 a640c23a62f3a-b7697e8b01aso774131266b.2
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 01 Dec 2025 01:16:23 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1764580583; x=1765185383;
 darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject
         :date:message-id:reply-to;
        bh=kqPi0VCHZNCcnU2bnDDFiAJ7iANnNTJSHn9Sg/c+ZT0=;
        b=rV/wIXTV71TIIRchjo9mit1krjYd5QeJkiK31uY+IQ8kKTyna4OYJM+zhicubghyCN
         lLOgc0X+iuQho0n+YzQtqZ4ShzQHD0J/U7/SDIfPiO/Twln+Qzffn/yzMTSZR4NPWo94
         aurY8KKS/F9e3G6ULpYljIewJ3Gtl8eyYU/sW2+IphaZ0ULfpGiw1UqdFRU/N5/TB7ax
         QYi9HcPUDGkdDtvi0FjhNkrxP5YBZLZYQD0yKoWfshfZFzMt/2fjUUhV4nVlFF00GFMG
         +1onvh9X/EzcP7z1NfNnskRAmm8e79adNojyc0koOq2tnMO6Xn+JvIazhF5uo11s+kkK
         dINA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1764580583; x=1765185383;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=kqPi0VCHZNCcnU2bnDDFiAJ7iANnNTJSHn9Sg/c+ZT0=;
        b=CJseq1Oh9uoQ4aCxs5pePpuPr89IgFe7cMZ+Pth32ZvihgVyplWwyQQmSid+MHtgYg
         1yKj5asZvBwSGXzGQ+uZ+qImjfO24bCqj6Pngv1FJGmokMALW/bNY4dtDqsBipe3TVlk
         L8NuQ38vY4OmTRjM2UvpxCTytSYGViqpp0KCTWv855oWcNYVS6vVX5ckzuxtSq/yhVIx
         2hMoZCXivv12hGabCUUiFbsWJaS+BG4PfVJoe7LHfEQHMIq9tZRnzqyAJfbVIUGtWOfL
         a5fMvN7mVONyL9UK7MnNPXqSVZ+kUhrKlNTGcQV4V/8c0CTMZ4zAts8RcG2Nh/+KlaDO
         97jw==
X-Gm-Message-State: AOJu0Yy8tyT5M1qas4v5wO1wd9bIGyF/m9M7p8BYDaIoczVtcQGaLhBD
	kNbDvFV+AfVG7oRCiqwd4Mukz1MIbGYvrvnZTi3bm3DIzOb4N9Wn31aDzIVKaTmJLMY=
X-Gm-Gg: ASbGnctdB4g17/9/pXGGy478qnV+iP+kwrWKNeNJn0aQ+feEC6INSkUvD5qaMsSKvUd
	5rQbdAo22c/mdbUqOxXz8/QGfUhnkjNkiHzZOkaeYbsMWP46sMo94ycA7GY4/upxPXzesn0+l8G
	JZqvvBBTzyAgf/IIlzSWYvA+e1IdDdgdET38MnwY0pRDcWaZssI1htrqi1/UdzOfkbwIj1L0cCP
	XlPX3V3Jk1T1B2tB98LhxWMdxYuD1MSToO1U6vTpS294lBZ1Z6/n4sClLSsqXYelXLnSclaO5bJ
	YDs2PlDbL431sEXs2rxAe6J7KcQVytIA/q7Zgr+ZgVifLu0vINGs4ILGpbqGswOqoZCle7uGXfl
	9p+k0GcZO6GytQb/FJSM6PzmxLeuYXw6q8es8ifkJol8m7uYc2jN8WanHYYzg3fvUkuZQ1AiRkX
	fYDlPnnQ1BjgU8adKBoRVARqv2Lc2iiupP/oXEKkvg
X-Google-Smtp-Source: 
 AGHT+IHmN1GppZcX3K7sEULS43lb2GTaYjU3+bS26WzRuJP0E8AGK0v00ssKLBePtdiTTYgwU/i+BA==
X-Received: by 2002:a17:907:2d10:b0:b3c:3c8e:189d with SMTP id
 a640c23a62f3a-b76716db3b5mr4324080166b.32.1764580582703;
        Mon, 01 Dec 2025 01:16:22 -0800 (PST)
Received: from laurenz.albe-K4N0CV00F97414D
 ([2001:871:70:4da6:f0e:8e32:27ad:b088])
        by smtp.gmail.com with ESMTPSA id
 a640c23a62f3a-b76f59aecc9sm1177811566b.43.2025.12.01.01.16.22
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 01 Dec 2025 01:16:22 -0800 (PST)
Message-ID: <e0194767654192b4209087584c0cf602fe90aadc.camel@cybertec.at>
Subject: Re: Migration from MSSQL to POSTGRESQL
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Raj <rajeshkumar.dba09@gmail.com>, Tayyab Fayyaz
 <tayyab.humayl@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Mon, 01 Dec 2025 10:16:21 +0100
In-Reply-To: 
 <CAJk5AtYYmxWH6Tbp-3dAiMKd3Ynu4J6ajtOc48rKsa1s3Kk0SA@mail.gmail.com>
References: 
	<CAJk5AtY9E2E3tL3=1zt82LBZK7Q8BkH65BNG=43oa3qWLrPAtg@mail.gmail.com>
	 <8db363787dc505e0dbe01ab48c437205928f1c2b.camel@cybertec.at>
	 <CAFVRaQ2zxmVY+zqADEv2hqo9uR6Q-iYn0v2MQ2EKUtv+yRZKsA@mail.gmail.com>
	 <CAJk5AtYYmxWH6Tbp-3dAiMKd3Ynu4J6ajtOc48rKsa1s3Kk0SA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
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/e0194767654192b4209087584c0cf602fe90aadc.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-12-01 at 14:07 +0530, Raj wrote:
> Please suggest based on Oracle.

My recommendation is the same, no matter from which database system you are=
 migrating.

Yours,
Laurenz Albe