Re: Incremental load from SQL server DB to postgressql

You could use the the /*ogc_fdw*/ foreign data wrapper.

It's a data wrapper for accessing spatial data using the GDAL library.
But it works just fine with non-spatial data too, including
MS-SqlServer. And it's well maintained.

Med venlig hilsen / Best regards

Bo Victor Thomsen

On 05-09-2024 16:01, Holger Jakobs wrote:
> You could try to use BCP.exe for exporting from MS SQL to a flat file
> per table. Load into PG SQL Server with COPY or \copy (psql).
>
> Using the TSQL foreign data wrapper to pull data over is another
> option. This FDW isn't very well maintained, though.
>
> Regards
> Holger
>
> --
> Holger Jakobs, Bergisch Gladbach
> Tel. +49 178 9759012
>
>
> Am 5. September 2024 15:54:31 MESZ schrieb Sabyasachi Mukherjee
> <mukherjee(dot)sabyasachi(at)outlook(dot)com>:
>
> 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
>