public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bo Victor Thomsen <[email protected]>
To: [email protected]
Subject: Re: Incremental load from SQL server DB to postgressql
Date: Thu, 5 Sep 2024 16:56:05 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
	<[email protected]>

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 
> <[email protected]>:
>
>     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)  latest in thread

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