| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | ivo silvestre <ivomts(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Connecting to SQL Server from Windows using FDW |
| Date: | 2016-01-22 18:18:22 |
| Message-ID: | 56A2726E.7040205@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2016-01-22 18:29:13 | Re: Let's Do the CoC Right |
| Previous Message | ivo silvestre | 2016-01-22 18:05:10 | Connecting to SQL Server from Windows using FDW |