Search Postgresql Archives

Re: Connecting to SQL Server from Windows using FDW

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/22/2016 10:05 AM, ivo silvestre wrote:
Hi,

I need to create a linked server between 2 Windows servers. In one I've
PostgreSQL with admin privileges and in the other MS SQL with only read
access.

I need to create a view (or a foreign table?) in PostgreSQL from a table
in MS SQL in another server. The table in the MS SQL is constantly
growing and I need on-the-fly access to the data.

After some web search I found GeoffMontee's Github, but I don't know how
to install it on Windows...

Is there anyone how already did something like this and could help me out..?

Seems like it is an open issue:

https://github.com/GeoffMontee/tds_fdw/issues/53


Thanks in advance!

Kind regards,

--
Ivo Silvestre
______________________
*técnico sig | gis technician*

<https://www.linkedin.com/in/ivomts>
______________________


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux