From: | ivo silvestre <ivomts(at)gmail(dot)com> |
---|---|
To: | "John J(dot) Turner" <fenwayriffs(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connecting to SQL Server from Windows using FDW |
Date: | 2016-01-23 09:08:21 |
Message-ID: | CABrj9cKx2c6ZBTdkuMcr3NVysX_fjqWEth2+Ki1b05cSun7YmA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
<http://www.postgresql.org/docs/current/static/postgres-fdw.html>, that
allow to link 2 different postgres servers, but in this case that doesn't
help me.
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.
>
> Cheers,
> John
>
>
--
Ivo Silvestre
______________________
*técnico sig | gis technician*
<https://www.linkedin.com/in/ivomts>
______________________
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-01-23 09:28:05 | Re: 9.5 new features |
Previous Message | Chris Travers | 2016-01-23 08:47:09 | Re: Let's Do the CoC Right |