Re: Linking tables from SQL Server

[Aitor Gil Martin <sigeo.agmartin@xxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] En nombre de Aitor Gil Martin
Enviado el: lunes, 30 de noviembre de 2015 11:30
Para: pgsql-admin@xxxxxxxxxxxxxx; Félix GERZAGUET
Asunto: Re: 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.gerzaguet@xxxxxxxxx]
Enviado el: jueves, 26 de noviembre de 2015 15:19
Para: Aitor Gil Martin
CC: pgsql-admin@xxxxxxxxxxxxxx
Asunto: Re: Linking tables from SQL Server

Hello,

On Thu, Nov 26, 2015 at 3:14 PM, Aitor Gil Martin <sigeo.agmartin@xxxxxxxxx> 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