MIME-Version: 1.0
References: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
In-Reply-To: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
From: Muhammad Usman Khan <usman.k@bitnine.net>
Date: Fri, 6 Sep 2024 08:44:20 +0500
Message-ID: 
 <CAPnRvGtkbRY=J2H6jJnN8bATgQFdnYsoL1wMsR2pPvPzvrgQEQ@mail.gmail.com>
Subject: Re: Incremental load from SQL server DB to postgressql
To: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000096f8d906216b394e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPnRvGtkbRY%3DJ2H6jJnN8bATgQFdnYsoL1wMsR2pPvPzvrgQEQ%40mail.gmail.com>
Precedence: bulk

--00000000000096f8d906216b394e
Content-Type: text/plain; charset="UTF-8"

Hi,

You can use  pgloader. It is a powerful tool that can migrate data from SQL
Server to PostgreSQL efficiently, and it supports incremental loads or the
other option is to use file_fdw, it allows PostgreSQL to directly query
flat files  as if they were tables, without importing the data into
PostgreSQL. It can be useful if you can periodically export data from SQL
Server into flat files and then query them from PostgreSQL.

On Thu, 5 Sept 2024 at 18:54, 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
>

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

<div dir=3D"ltr"><font face=3D"arial, sans-serif"><br clear=3D"all"></font>=
<div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_sig=
nature"><div dir=3D"ltr"><font face=3D"arial, sans-serif"><span></span></fo=
nt><div><font face=3D"arial, sans-serif">Hi,</font></div><div><font face=3D=
"arial, sans-serif"><br>You can use=C2=A0

pgloader. It is a powerful tool that can migrate data from SQL Server to Po=
stgreSQL efficiently, and it supports incremental loads or the other option=
 is to use=C2=A0<code style=3D"">file_fdw, it=C2=A0</code>allows PostgreSQL=
 to directly query flat files=C2=A0 as if they were tables, without importi=
ng the data into PostgreSQL. It can be useful if you can periodically expor=
t data from SQL Server into flat files and then query them from PostgreSQL.=
</font></div></div></div></div></div><br><div class=3D"gmail_quote"><div di=
r=3D"ltr" class=3D"gmail_attr">On Thu, 5 Sept 2024 at 18:54, Sabyasachi Muk=
herjee &lt;<a href=3D"mailto:mukherjee.sabyasachi@outlook.com">mukherjee.sa=
byasachi@outlook.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div class=3D"msg8586073421672887162">


<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>

</div></blockquote></div>

--00000000000096f8d906216b394e--