From: <lennam@incisivetechgroup.com>
To: "'Sabyasachi Mukherjee'" <mukherjee.sabyasachi@outlook.com>,
	<pgsql-admin@lists.postgresql.org>
References: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
In-Reply-To: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Subject: RE: Incremental load from SQL server DB to postgressql
Date: Sun, 8 Sep 2024 18:01:33 -0400
Message-ID: <02ba01db023a$abd89c20$0389d460$@incisivetechgroup.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_02BB_01DB0219.24C79860"
Thread-Index: AQNKlB7/6tfm9xGe/kqNa4Oe3bruwq9vTBdA
Content-Language: en-us
Archived-At: 
 <https://www.postgresql.org/message-id/02ba01db023a%24abd89c20%240389d460%24%40incisivetechgroup.com>
Precedence: bulk

This is a multipart message in MIME format.

------=_NextPart_000_02BB_01DB0219.24C79860
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Option  use ELT tool , if PostgreSQL in Azure use Azure Data Factory 

Option 2 , write SQL statements to extract data in PostgreSQL format , load
into PostgreSQL using \copy  command

If AWS use Schema Conversion Tool (SCT)  along with Database Migration
Services (DMS)

 
From: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com> 
Sent: Thursday, September 5, 2024 9:55 AM
To: pgsql-admin@lists.postgresql.org
Subject: Incremental load from SQL server DB to postgressql

 
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


------=_NextPart_000_02BB_01DB0219.24C79860
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 15 =
(filtered medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;
	mso-ligatures:none;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US =
link=3D"#0563C1" vlink=3D"#954F72" style=3D'word-wrap:break-word'><div =
class=3DWordSection1><p class=3DMsoNormal>Option &nbsp;use ELT tool , if =
PostgreSQL in Azure use Azure Data Factory <o:p></o:p></p><p =
class=3DMsoNormal>Option 2 , write SQL statements to extract data in =
PostgreSQL format , load into PostgreSQL using \copy =
&nbsp;command<o:p></o:p></p><p class=3DMsoNormal>If AWS use Schema =
Conversion Tool (SCT) &nbsp;along with Database Migration Services =
(DMS)<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><div =
style=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in =
0in 0in'><p class=3DMsoNormal><b>From:</b> Sabyasachi Mukherjee =
&lt;mukherjee.sabyasachi@outlook.com&gt; <br><b>Sent:</b> Thursday, =
September 5, 2024 9:55 AM<br><b>To:</b> =
pgsql-admin@lists.postgresql.org<br><b>Subject:</b> Incremental load =
from SQL server DB to postgressql<o:p></o:p></p></div></div><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><div><p class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:black'>Hello =
All,<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:black'><o:p>&nbsp;</o:p></span></p></div>=
<div><p class=3DMsoNormal><span style=3D'font-size:12.0pt;color:black'>I =
have to implement an incremental load from a SQL server DB to a =
postgresql DB. I&nbsp;would prefer it to be pull from =
postgres.<o:p></o:p></span></p></div><div><p class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:black'>SSIS is not the preferred option. =
Can you please advise about the =
possibilities?<o:p></o:p></span></p></div><div><p =
class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:black'><o:p>&nbsp;</o:p></span></p></div>=
<div><p class=3DMsoNormal><span =
style=3D'font-size:12.0pt;color:black'>Sabyasachi =
Mukherjee<o:p></o:p></span></p></div></div></body></html>
------=_NextPart_000_02BB_01DB0219.24C79860--