Content-Type: multipart/alternative;
 boundary="------------7J29NWMUeRMdF9InHovQQkeG"
Message-ID: <2e6fb4e8-2854-4eea-96ba-af2e5212b4e1@gmail.com>
Date: Thu, 5 Sep 2024 16:56:05 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Incremental load from SQL server DB to postgressql
To: pgsql-admin@lists.postgresql.org
References: 
 <DB4PR10MB74698366CBE50504439DF6D98C9D2@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
 <7D5A40F7-855D-4E14-9866-A6C22CA79327@jakobs.com>
Content-Language: en-GB, da
From: Bo Victor Thomsen <bo.victor.thomsen@gmail.com>
In-Reply-To: <7D5A40F7-855D-4E14-9866-A6C22CA79327@jakobs.com>
Archived-At: 
 <https://www.postgresql.org/message-id/2e6fb4e8-2854-4eea-96ba-af2e5212b4e1%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------7J29NWMUeRMdF9InHovQQkeG
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.sabyasachi@outlook.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
>
--------------7J29NWMUeRMdF9InHovQQkeG
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>You could use the the <i><b>ogc_fdw</b></i> foreign data
      wrapper. </p>
    <p><br>
    </p>
    <p>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.</p>
    <p><br>
    </p>
    <pre class="moz-signature" cols="72">Med venlig hilsen / Best regards

Bo Victor Thomsen</pre>
    <div class="moz-cite-prefix">On 05-09-2024 16:01, Holger Jakobs
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:7D5A40F7-855D-4E14-9866-A6C22CA79327@jakobs.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
      <div dir="auto">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).<br>
        <br>
        Using the TSQL foreign data wrapper to pull data over is another
        option. This FDW isn't very well maintained, though.<br>
        <br>
        Regards <br>
        Holger<br>
        <br>
      </div>
      <div dir="auto">
        <div class="k9mail-signature">-- <br>
          Holger Jakobs, Bergisch Gladbach <br>
          Tel. +49 178 9759012</div>
      </div>
      <br>
      <br>
      <div class="gmail_quote">
        <div dir="auto">Am 5. September 2024 15:54:31 MESZ schrieb
          Sabyasachi Mukherjee <a class="moz-txt-link-rfc2396E" href="mailto:mukherjee.sabyasachi@outlook.com">&lt;mukherjee.sabyasachi@outlook.com&gt;</a>:</div>
        <blockquote class="gmail_quote"
style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
          <div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
            Hello All,</div>
          <div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
            <br>
          </div>
          <div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
            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.</div>
          <div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
            SSIS is not the preferred option. Can you please advise
            about the possibilities?</div>
          <div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
            <br>
          </div>
          <div class="elementToProof"
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
            Sabyasachi Mukherjee</div>
        </blockquote>
      </div>
    </blockquote>
  </body>
</html>

--------------7J29NWMUeRMdF9InHovQQkeG--