RE: Incremental load from SQL server DB to postgressql

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(dot)sabyasachi(at)outlook(dot)com>
Sent: Thursday, September 5, 2024 9:55 AM
To: pgsql-admin(at)lists(dot)postgresql(dot)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