Subject: Re: How to access data of SQL server database from
 PostgreSQL
To: Daulat Ram <Daulat.Ram@cyient.com>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
References: <9dbf50ba381a4d9eae625823411f5ccf@cyient.com>
From: Anthony Sotolongo <asotolongo@gmail.com>
Message-ID: <c13c1a18-ce7c-d66c-1094-633d1d7cc114@gmail.com>
Date: Tue, 1 Aug 2017 09:06:17 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.2.1
MIME-Version: 1.0
In-Reply-To: <9dbf50ba381a4d9eae625823411f5ccf@cyient.com>
Content-Type: multipart/alternative;
 boundary="------------BD89157FE7F8470441A0CF0A"
Content-Language: es-ES
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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

Hi Daulat


This is not the list for that (check https://www.postgresql.org/list/), 
but if you want to access sql server look at tds_fdw( 
https://github.com/tds-fdw/tds_fdw), I do not know if it installs on 
windows, I've only used it on linux, and function very well.

Regards
Anthony

On 01/08/17 00:25, Daulat Ram wrote:
>
> Hi team,
>
> I need to connect to MS-SQL server 2008/2012 from PostgreSQL 9.5 in 
> Windows7 environment to fetch the tables of SQL server.
>
> Please help on this.
>
> Regards,
>
> Daulat
>
>
> ------------------------------------------------------------------------
>
> DISCLAIMER:
>
> This email message is for the sole use of the intended recipient(s) 
> and may contain confidential and privileged information. Any 
> unauthorized review, use, disclosure or distribution is prohibited. If 
> you are not the intended recipient, please contact the sender by reply 
> email and destroy all copies of the original message. Check all 
> attachments for viruses before opening them. All views or opinions 
> presented in this e-mail are those of the author and may not reflect 
> the opinion of Cyient or those of our affiliates.


--------------BD89157FE7F8470441A0CF0A
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1252">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi Daulat<br>
    </p>
    <p><br>
    </p>
    <p>This is not the list for that (check
      <a class="moz-txt-link-freetext" href="https://www.postgresql.org/list/">https://www.postgresql.org/list/</a>), but if you want to access sql
      server look at tds_fdw( <a class="moz-txt-link-freetext" href="https://github.com/tds-fdw/tds_fdw">https://github.com/tds-fdw/tds_fdw</a>), I do
      not know if it installs on windows, I've only used it on linux,
      and function very well.<br>
    </p>
    Regards<br>
    Anthony<br>
    <br>
    <div class="moz-cite-prefix">On 01/08/17 00:25, Daulat Ram wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:9dbf50ba381a4d9eae625823411f5ccf@cyient.com">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal">Hi team,<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">I need to connect to MS-SQL server
          2008/2012 from PostgreSQL 9.5 in Windows7 environment to fetch
          the tables of SQL server.<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Please help on this.<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal">Regards,<o:p></o:p></p>
        <p class="MsoNormal">Daulat<o:p></o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
        <p class="MsoNormal"><o:p> </o:p></p>
      </div>
      <br>
      <hr>
      <font size="1" face="Arial" color="Gray"><br>
        DISCLAIMER:<br>
        <br>
        This email message is for the sole use of the intended
        recipient(s) and may contain confidential and privileged
        information. Any unauthorized review, use, disclosure or
        distribution is prohibited. If you are not the intended
        recipient, please contact the sender by reply email and destroy
        all copies of the original message. Check all attachments for
        viruses before opening them. All views or opinions presented in
        this e-mail are those of the author and may not reflect the
        opinion of Cyient or those of our affiliates.<br>
      </font>
    </blockquote>
    <br>
  </body>
</html>

--------------BD89157FE7F8470441A0CF0A--