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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1smCwa-0042YU-ME
	for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 13:54:41 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1smCwZ-00B36R-9g
	for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 13:54:39 +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.94.2)
	(envelope-from <mukherjee.sabyasachi@outlook.com>)
	id 1smCwY-00B35N-Pm
	for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 13:54:39 +0000
Received: from mail-vi1eur05olkn2036.outbound.protection.outlook.com
 ([40.92.90.36] helo=EUR05-VI1-obe.outbound.protection.outlook.com)
	by magus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <mukherjee.sabyasachi@outlook.com>)
	id 1smCwX-000IGt-4B
	for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 13:54:38 +0000
ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none;
 b=ARDsuFg9tKqBWtBGheTs64q9OPWuQz6vbEcvKOiiD0dz7DHBw1GZg32zB3tL7NSEX4FCMEwJSGYuwxX6hmb3cqlLFbusVoqTP7mcMgj0nBpjRDkP90QgOYavaXsZAjQfWgNMm1RLl0rkTBWcS79RmsptPlD3Y9SobGE0s59nkCJ0F4TFN3MzLc9oapDNZWzW0CMZ/HMPUTAZJS/i4zZ17s8ueDiR2ylutzYkkpxHviTZZG8tqs8KI4aA0LIqzpiMIrKwlcr49uRgoZP9hy8+69hAR49FVm0VRxCIYPUWhA9P4u6chhXMnLs1xb0IHee4Hug3PxsMviALHMv7AztH6A==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector10001;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=00HCGPn42w+WchbySnoOw5t300lljSfZ9y2FULdc8ug=;
 b=cIC7Fm0ONh/PZ+/zigc7NonKYIwjA597PLxdGknUSJrVgbjNi6rO2ArZWpXckSkq3lwYmmQcH1XsaYfgffAjQ5yQn2Ui2eDRoaFGMGwx5Zk/LtQ64yuXIE/rOu7/nroSvjC30StY5LYCM+XiRD1dozd35D8vPRSn/2rbJNdqC4rgIqEpuQ/F8beMTmvjBdzXFaxWZnzaj1TNFmfj1v1+8FqgiGusr+f0DJ+pqprOlg+bF3mE5nEJsoLnOHuB/l/GYBUj7SFXmPqcwwF2wRwLAtLB2lzi/XdvlimjZYoOH1rY5K8P3FLouzmfw5ZbD1beh5A+zHqO2CuCoaBHqvUc2A==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none;
 dkim=none; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com;
 s=selector1;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=00HCGPn42w+WchbySnoOw5t300lljSfZ9y2FULdc8ug=;
 b=CLAtuR5NsOcHyzPPnhPp/vGhRZ8+Gf5oa0KCktxc82aX0KYnjwL08p8gE76gr6hRN39IEJmL05CfumHvO0c0DSWyK/ya+MUXoQrcrfwYgMUN0EpE9J+MtP8c2f0kA7LCav0zMTBKHss6tV5hXgV6Ad71UJIOYMoWCDcX6dcf/+l5WVg4vH8ZzSaAM7+zaRgjR+RBAvBFF8zWrJNP0mzclisnituqRrnJgcAvXujSupiJlIjnQEy0IU6h4PfcCAnWtyff2xpSTBXhB7eS6XGpFDFl1JfQvHkewYfg+3U4rxzGTf9PHdj8WhFsJZz8mMNlAREVqmwSRjSzOOJppE1VLw==
Received: from DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:10:3cf::15)
 by GVXPR10MB8615.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:150:1e8::7) with
 Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7918.27; Thu, 5 Sep
 2024 13:54:31 +0000
Received: from DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
 ([fe80::e113:72f1:4ad7:3c24]) by DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
 ([fe80::e113:72f1:4ad7:3c24%3]) with mapi id 15.20.7918.024; Thu, 5 Sep 2024
 13:54:31 +0000
From: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Incremental load from SQL server DB to postgressql
Thread-Topic: Incremental load from SQL server DB to postgressql
Thread-Index: AQHa/5rt/R4iiw0n/USoxRMcR6H/dg==
Date: Thu, 5 Sep 2024 13:54:31 +0000
Message-ID: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Accept-Language: en-IN, en-US
Content-Language: en-IN
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
msip_labels: 
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [zmeDF7sWWBAng74+0oAIsIzNab2Bex/ACCj0Pa3fpB0=]
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: DB4PR10MB7469:EE_|GVXPR10MB8615:EE_
x-ms-office365-filtering-correlation-id: b1c0dee7-c486-4db1-5208-08dccdb24456
x-microsoft-antispam: 
 BCL:0;ARA:14566002|461199028|15080799006|19110799003|8060799006|15030799003|440099028|3412199025|102099032;
x-microsoft-antispam-message-info: 
 FKyeIkMPkt9lTlKyCkgh0oNYG1wrKGjfyFeT9b0l8ntmt6FGeILy1StRmhO2qkybO0BXHZu6DPenKZZuZ1vcjrkdlmDxpWtq9jSb064ZZDR8/WB90nhH0Jks3gGBNBosSEuglu7iJc6KUkL+Vvn6wd0Ijz4X89To5Rk09XbhW/+Vz4x774+M58AheE3KNfXlegye8JAvZ68XY5HYPWy6vapzikOabDkSEsRPxoWo83raddN68/Uq1nHt3Uv9ElMpDlhDs87t2/4al3XYsf39UCQrBhfRpQ62FH5fBB3vyLX9BBVJuIOKYM0aurbbb92T+FzcQmDelV5QyPLsgMffKxYA0p0uknfdg/6CCIcn4IXwnJ6djq7rLuXAhH93JlCm31G5qzppb4MP1jOyi7XzcABGce25GlyAojuAADeDhy+y4TP9lQLRXzADZ1tBcuMaNjUrZhmuBL8zGe1cAPB6yZj5shUUWFqVRwcFmRLnSygTYetGIxhsDWJTP4Kj9gn5FlkgDVUMEVV1kb2zReTpNXMLDBrx8rQk182ZJdXyjq7l4mmwD+g8oeaw9jCjG1+WXolhmdMhc+W7Nhn1iol65w/d1cNB3mU0lVlmLoKVUI6Mvxy+8p9guB+QXpGMvtiH4KoJdT2r6ECvEx0/keo+H7XIB6xAS6f4JQ9Sb6C8GnVd4zS76g69+H27VlKLe+7X2gg2JnpJ0GR/G/triungJw==
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?BP+T4Wozv9lQdS5uaxOSBWaf/Qb+5KJN/y+1Ovr1Mp8gX+VnZ6oZJ1ddZ/?=
 =?iso-8859-1?Q?D3kXkpF5R/aFPUEfGVo1Jxe2cikJpX6klsNaXj7QRyOuHVx0gF0wbOTUM8?=
 =?iso-8859-1?Q?rquuOzXMswg1/yK7MzAWJ7eyY3FjqvEbZt+b+9CMuomZtxEPzLlko2aMeI?=
 =?iso-8859-1?Q?XYBXn3qS+YItqd4HRxmimpwsRnnvli666ZD/3S9vPLRCe+MKHjj5EFjP2v?=
 =?iso-8859-1?Q?KbF1AHShLXvsY+WFllzmJ6WGLV7WTSXTudtSs9ojUAIXtwDiZFYswOp1Kb?=
 =?iso-8859-1?Q?vnrGjAC09wGYeouHdi7WBzo1+pZT/O9R+BTWavOuYZzw0RLHSnrUAggTMH?=
 =?iso-8859-1?Q?qdgF1zcbwxWbjpRXvRB6CztwZy3Gc8kkzqbXYDdEATOLBIO9DdSOhcg5VS?=
 =?iso-8859-1?Q?hYRtcYkHDtpPQ0cBI0T8fs5XAmRbUMUqMHLWYYEO2FHi5t87gBgjPDynhG?=
 =?iso-8859-1?Q?gPalXQY6sz+HEssI9wSPxQCyMWJDhbwG4CGhgtYY6sCNp+90q73PqHeM6l?=
 =?iso-8859-1?Q?PnH7zTdXK+LawwNL5vA2Qe5TstkqG+peXOkC1sI+VRN0LWuQIZiWT44m9o?=
 =?iso-8859-1?Q?ycydWvGAbGnDdbr7XmSw4V07IVSQFGeEkhT01uUbATnB5gxCwtEegxqjt8?=
 =?iso-8859-1?Q?D2MzxQXHs9Z2ZEtql6/9T++8uBWEum3oWlvRpibkGBMfqKAyNTR+7umRUz?=
 =?iso-8859-1?Q?9ijixGiKU0OIOOCWBVMNKnIoM5rVmrs+nVrxH65I+shhxsdQdrztNKIdy2?=
 =?iso-8859-1?Q?rcJb1alQLkF4A9LBvKWjo0pVl6KMoqDUqr7IUTRM1ngtWDzooAfKKX2+Hr?=
 =?iso-8859-1?Q?/H8c2Do8gpj4OBFh5342OAs0+eOx1S1ek0YqsUJeaOOWeYEMKJ04XZlpOy?=
 =?iso-8859-1?Q?4G5wn/aOdyXqrKNOn8ET0hKEPPDu0DwhlWK1hQGOS0FMkvWsRc7PXS3JTE?=
 =?iso-8859-1?Q?BC5I12Rrc498ycZJceqXJeTN5abCVA8dy9MMw2+MeUDw8ZkvDruMOWJcgO?=
 =?iso-8859-1?Q?pdEfhGVlQYPzAq6mtV3nr8n28vwWG/+zpShDkaUrnKZP1BcjCTeJKSdwqS?=
 =?iso-8859-1?Q?KBT/6ZtoNu5LKZKblPrBPoR8q1ztb+eFbUZt6WPBvHQm2N3YlxMd8Bya54?=
 =?iso-8859-1?Q?44aEQKXhe662OSsOf4y/kYcfUKcyIarqg9fpiL09TfAwNn21R0yedJBSW1?=
 =?iso-8859-1?Q?XYl5MgNVe154+A/Ud7JtZJtHfhy1JVdHqxsVCFS1L6s1GsG5bnkIKNLcNW?=
 =?iso-8859-1?Q?n7RU5iBTQ9lMe3/+KpNfB198OqOMra4DGfbbGGvqpaqslVyGIl6o8R/sUh?=
 =?iso-8859-1?Q?+1rY?=
Content-Type: multipart/alternative;
	boundary="_000_DB4PR10MB74698366CBE50504439DF6D98C9D2DB4PR10MB7469EURP_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 b1c0dee7-c486-4db1-5208-08dccdb24456
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Sep 2024 13:54:31.3594
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: GVXPR10MB8615
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/DB4PR10MB74698366CBE50504439DF6D98C9D2%40DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_DB4PR10MB74698366CBE50504439DF6D98C9D2DB4PR10MB7469EURP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello All,

I have to implement an incremental load from a SQL server DB to a postgresq=
l DB. I would prefer it to be pull from postgres.
SSIS is not the preferred option. Can you please advise about the possibili=
ties?

Sabyasachi Mukherjee

--_000_DB4PR10MB74698366CBE50504439DF6D98C9D2DB4PR10MB7469EURP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello All,</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I have to implement an incremental load from a SQL server DB to a postgresq=
l DB. I&nbsp;would prefer it to be pull from postgres.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
SSIS is not the preferred option. Can you please advise about the possibili=
ties?</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Sabyasachi Mukherjee</div>
</body>
</html>

--_000_DB4PR10MB74698366CBE50504439DF6D98C9D2DB4PR10MB7469EURP_--