Обсуждение: Linking tables from SQL Server
Hi,
Is there a way of connecting to tables in SQL Server (2008 R2) from PostgreSQL?
I am in PostgreSQL 9.3.5 and i don't find any way of creating a linked table stored in SQL Server...
Regards,
Aitor
Hello,
On Thu, Nov 26, 2015 at 3:14 PM, Aitor Gil Martin <sigeo.agmartin@getxo.eus> wrote:
Is there a way of connecting to tables in SQL Server (2008 R2) from PostgreSQL?
Regards,
Félix
> Hello, > > On Thu, Nov 26, 2015 at 3:14 PM, Aitor Gil Martin > <sigeo.agmartin@getxo.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 > It works wonders!!!!!!!!!!!!!!!!!!!! Saludos, Gilberto Castillo ETECSA, La Habana, Cuba
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@gmail.com]
Enviado el: jueves, 26 de noviembre de 2015 15:19
Para: Aitor Gil Martin
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Linking tables from SQL Server
Hello,
On Thu, Nov 26, 2015 at 3:14 PM, Aitor Gil Martin <sigeo.agmartin@getxo.eus> wrote:
Is there a way of connecting to tables in SQL Server (2008 R2) from PostgreSQL?
Regards,
Félix
I finally did it follwing this guide:
And using these files:
FDW binaries for PostgreSQL 9.4
Requirements:
PostgreSQL 9.4
PostGIS 2.2
Thanks.
De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] En nombre de Aitor Gil Martin
Enviado el: lunes, 30 de noviembre de 2015 11:30
Para: pgsql-admin@postgresql.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.gerzaguet@gmail.com]
Enviado el: jueves, 26 de noviembre de 2015 15:19
Para: Aitor Gil Martin
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Linking tables from SQL Server
Hello,
On Thu, Nov 26, 2015 at 3:14 PM, Aitor Gil Martin <sigeo.agmartin@getxo.eus> wrote:
Is there a way of connecting to tables in SQL Server (2008 R2) from PostgreSQL?
Regards,
Félix