| From: | ivo silvestre <ivomts(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Connecting to SQL Server from Windows using FDW |
| Date: | 2016-01-22 18:05:10 |
| Message-ID: | CABrj9cJEoYSGokEVv4f2LP6CcFSqN2MbZ_F=7vVFd0SCy8zk0A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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*
<https://www.linkedin.com/in/ivomts>
______________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-01-22 18:18:22 | Re: Connecting to SQL Server from Windows using FDW |
| Previous Message | Geoff Winkless | 2016-01-22 17:44:57 | Re: Let's Do the CoC Right |