Postgres Pro
Downloads
Home   >   mailing lists

RE: Incremental load from SQL server DB to postgressql - Mailing list pgsql-admin

From
Subject RE: Incremental load from SQL server DB to postgressql
Date
Msg-id 02ba01db023a$abd89c20$0389d460$@incisivetechgroup.com
Whole thread Raw
In response to Incremental load from SQL server DB to postgressql  (Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore and materialized view deps
Next
From: Wasim Devale
Date:
Subject: data_checksums = off