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 1smDDO-0044Zc-1w
	for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 14:12:02 +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 1smDDM-00BN1E-3Q
	for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 14:12:00 +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 <wasimd60@gmail.com>)
	id 1smDDL-00BN15-OL
	for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 14:12:00 +0000
Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <wasimd60@gmail.com>)
	id 1smDDJ-000IOG-N8
	for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 14:11:59 +0000
Received: by mail-ej1-x635.google.com with SMTP id
 a640c23a62f3a-a8692bbec79so121127866b.3
        for <pgsql-admin@lists.postgresql.org>;
 Thu, 05 Sep 2024 07:11:57 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1725545516; x=1726150316;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=gpDOvBYnRcxvlPfsvzUKxT65jZHGSneHbOkHCY0NCEo=;
        b=ONVXZp591PiBZmMcVoWaJzFKSdOK0H8NIJt8AZOtUwxpppYF51ipQOq3bQDTuOEwbu
         Ip8Q6aidGpnXZ6+4IoFGxsI2bWp06HEU+cPi3plBT4CMS+sI3vHmM0vZWEWtjN+EHs9z
         dvfh84T1Zt0nkShZXzmEm+1V048toKcVYsgIOXGRqWk8fidHyvwJ5u8ag1MfvOBLNdfV
         DL5UbwVJFRFKqP8Nbjt/6EWhKwhAbJeLiT3ZM2p6ZkNw37J7i05Yivhoht/wJOYwR7oo
         hTTsJQT5CKcaLPPBOS8OPq38Hxur5ehZlJ9wHed05Un93833jnPcxw7t7JDAtFR0r8kS
         SH2w==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1725545516; x=1726150316;
        h=cc: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=gpDOvBYnRcxvlPfsvzUKxT65jZHGSneHbOkHCY0NCEo=;
        b=NamDggN3tsbm//xMi3QaEDLB7Ve0mr89Rt8GQWW+0AZvdckRiz8UJVRZcypdlZH/f1
         5zsvuP4DbJVFd2DNmj0/yAuouz3Li7zsiXZGPoPXIwHfnvw3caWhMlemdi8kNvuCprWm
         BZy3PSWC14du6fmNy54VDJNU/Voi3O/+j/K+ZTIlUHTJi+rcSg/c9C/H3f7vygTjhNAk
         JGEYePnGYD2j949WmlzJuFJmAiw51Vy607CeWYHnWRmTFzOdHS1sefPB3X9kG4TmKCVx
         JXn5oemQ+jl9RRCpmPJo/f3+NG9oBVwU4Qm53YOdn0aTTgImS93gdrR+CaGdjHP3pNOX
         5pUQ==
X-Gm-Message-State: AOJu0YzD9WRJIEhC8/kbBSoIudX0jN0fjP0sRUQSz1xn+qBz9SlTg68u
	qRMqlIWrrumfDTVQLsfn7yy0gY4qUe92NfeHXAPrxaXz7TY/yZCAXPH+XKVaH97B4/OfO0rg4FM
	QxyXYEIIINKjxuOZP+QYN5LD+2tqzL/IF
X-Google-Smtp-Source: 
 AGHT+IGlOlkP6zLLop2a8/deiuX7XWCBlAzdBRTPBPrTdmMYpUP/ZfiP2BcNTM1DzQvSOvlhbmmCjmFI57J06I0WeQU=
X-Received: by 2002:a17:907:12cd:b0:a8a:3f78:7b7b with SMTP id
 a640c23a62f3a-a8a3f79d5a5mr313235266b.14.1725545515824; Thu, 05 Sep 2024
 07:11:55 -0700 (PDT)
MIME-Version: 1.0
References: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
In-Reply-To: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
From: Wasim Devale <wasimd60@gmail.com>
Date: Thu, 5 Sep 2024 19:41:28 +0530
Message-ID: 
 <CAB5fag6Xy5Og5gQXUNYsWXd9kxXFmQyY64w5zP_=PNz-TOuVqA@mail.gmail.com>
Subject: Re: Incremental load from SQL server DB to postgressql
To: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000083bce706215fdfc1"
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/CAB5fag6Xy5Og5gQXUNYsWXd9kxXFmQyY64w5zP_%3DPNz-TOuVqA%40mail.gmail.com>
Precedence: bulk

--00000000000083bce706215fdfc1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

ADF Pipeline would be great for your need.

Thanks,
Wasim

On Thu, 5 Sept, 2024, 7:24=E2=80=AFpm Sabyasachi Mukherjee, <
mukherjee.sabyasachi@outlook.com> wrote:

> Hello All,
>
> I have to implement an incremental load from a SQL server DB to a
> postgresql DB. I would prefer it to be pull from postgres.
> SSIS is not the preferred option. Can you please advise about the
> possibilities?
>
> Sabyasachi Mukherjee
>

--00000000000083bce706215fdfc1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">ADF Pipeline would be great for your need.<div dir=3D"aut=
o"><br></div><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Wasim</div></=
div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On=
 Thu, 5 Sept, 2024, 7:24=E2=80=AFpm Sabyasachi Mukherjee, &lt;<a href=3D"ma=
ilto:mukherjee.sabyasachi@outlook.com">mukherjee.sabyasachi@outlook.com</a>=
&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">




<div dir=3D"ltr">
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
Hello All,</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Calibri,Helvetica,sans-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=C2=A0would prefer it to be pull from postgres.</div>
<div style=3D"font-family:Calibri,Helvetica,sans-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 style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)">
Sabyasachi Mukherjee</div>
</div>

</blockquote></div>

--00000000000083bce706215fdfc1--