From: | "John J(dot) Turner" <fenwayriffs(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connecting to SQL Server from Windows using FDW |
Date: | 2016-01-23 13:50:15 |
Message-ID: | 2C7EA0FA-8320-4632-8A6F-B3A664C0631E@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 23 January 2016 at 04:40, John J. Turner <fenwayriffs(at)gmail(dot)com> wrote:
> On Jan 22, 2016, at 1:05 PM, ivo silvestre <ivomts(at)gmail(dot)com> wrote:
>
> > 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 ...
> > ... I found GeoffMontee's Github, but I don't know how to install it on Windows...
>
> Perhaps this link may help:
> https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration--part-3/
>
> The only caveat I see offhand is the use of the 'sa' account, but I can't vouch for that being a required mapping.
On Jan 23, 2016, at 4:08 AM, ivo silvestre <ivomts(at)gmail(dot)com> wrote:
> Hi John,
>
> Thanks, but I already saw that link. The problem is to installing the tds_fwd extension on postgres. And I don't know how to (never tried) compile it...
>
> What comes with postgres by default is the postgres fdw, that allow to link 2 different postgres servers, but in this case that doesn't help me.
Sorry Ivo, my bad - I managed to gloss over the salient point for your issue in this link - you're on Windows, his Postgres was on Linux!
Compiling an extension on Windows, last time I tried many moons ago was unfortunately not successful, which involved compiling the whole pg source tree via MinGW.
Hazarding a thought - although it's discontinued, it might be worth checking out Windows Subsystem for UNIX-based Applications (SUA):
https://en.wikipedia.org/wiki/Windows_Services_for_UNIX
But I suspect anything you managed to compile with that would still be incompatible with your pg instance...
Beyond that, perhaps the gurus here have some sage advice...
- John
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-01-23 15:12:43 | Re: Building PostgreSQL 9.6devel sources with Microsoft Visual C++ 2015? |
Previous Message | FarjadFarid(ChkNet) | 2016-01-23 10:49:27 | Re: 9.5 new features |