Re: Linking tables from SQL Server

I finally did it follwing this guide:

http://www.postgresonline.com/journal/archives/339-OGR-foreign-data-wrapper-on-Windows-first-taste.html

And using these files:

FDW binaries for PostgreSQL 9.4
http://www.postgresonline.com/journal/archives/340-Foreign-Data-Wrappers-for-PostgreSQL-9.4-Windows.html

Requirements:

PostgreSQL 9.4
PostGIS 2.2

Thanks.

________________________________
De: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] En nombre de Aitor Gil Martin
Enviado el: lunes, 30 de noviembre de 2015 11:30
Para: pgsql-admin(at)postgresql(dot)org; Félix GERZAGUET
Asunto: Re: [ADMIN] Linking tables from SQL Server

Thanks for your help Félix.

I can see that these files are for linux or centos. Is there a way of using them in Windows?

I am not capable of making it work..... :(

________________________________
De: Félix GERZAGUET [mailto:felix(dot)gerzaguet(at)gmail(dot)com]
Enviado el: jueves, 26 de noviembre de 2015 15:19
Para: Aitor Gil Martin
CC: pgsql-admin(at)postgresql(dot)org
Asunto: Re: [ADMIN] Linking tables from SQL Server

Hello,

On Thu, Nov 26, 2015 at 3:14 PM, Aitor Gil Martin <sigeo(dot)agmartin(at)getxo(dot)eus<mailto:sigeo(dot)agmartin(at)getxo(dot)eus>> wrote:
Is there a way of connecting to tables in SQL Server (2008 R2) from PostgreSQL?

You could have a look at: https://github.com/GeoffMontee/tds_fdw

Regards,
Félix