Обсуждение: Linking tables from SQL Server

Поиск
Список
Период
Сортировка

Linking tables from SQL Server

От
Aitor Gil Martin
Дата:
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
 

Re: Linking tables from SQL Server

От
Félix GERZAGUET
Дата:
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

Regards,
Félix

Re: [MASSMAIL]Re: Linking tables from SQL Server

От
"Gilberto Castillo"
Дата:
> 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

Re: Linking tables from SQL Server

От
Aitor Gil Martin
Дата:
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?

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

Regards,
Félix

Re: Linking tables from SQL Server

От
Aitor Gil Martin
Дата:
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?

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

Regards,
Félix