Postgres Pro
Downloads
Home   >   mailing lists

Connecting to SQL Server from Windows using FDW - Mailing list pgsql-general

From ivo silvestre
Subject Connecting to SQL Server from Windows using FDW
Date
Msg-id CABrj9cJEoYSGokEVv4f2LP6CcFSqN2MbZ_F=7vVFd0SCy8zk0A@mail.gmail.com
Whole thread Raw
Responses Re: Connecting to SQL Server from Windows using FDW
Re: Connecting to SQL Server from Windows using FDW
List pgsql-general
Tree view
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..?
 
Thanks in advance!

Kind regards,

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


______________________

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: Let's Do the CoC Right
Next
From: Adrian Klaver
Date:
Subject: Re: Connecting to SQL Server from Windows using FDW