public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: 'Sabyasachi Mukherjee' <[email protected]>
To: [email protected]
Subject: RE: Incremental load from SQL server DB to postgressql
Date: Sun, 8 Sep 2024 18:01:33 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
References: <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>

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 <[email protected]> 
Sent: Thursday, September 5, 2024 9:55 AM
To: [email protected]
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

view thread (6+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: RE: Incremental load from SQL server DB to postgressql
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox