Обсуждение: [PERFORM] How to access data of SQL server database from PostgreSQL

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

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.

On 07/31/2017 09:25 PM, 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.

https://github.com/tds-fdw/tds_fdw

JD

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


--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
*****     Unless otherwise stated, opinions are my own.   *****