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