| From: | Justin <zzzzz(dot)graf(at)gmail(dot)com> |
|---|---|
| To: | Soni M <diptatapa(at)gmail(dot)com> |
| Cc: | "pgsql general (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Encrypted connection SQL server fdw |
| Date: | 2020-01-10 16:36:51 |
| Message-ID: | CALL-XeO+RSVhYMbDAv7j7c0bdODvuwycw67KhAmt5Fb_9K-ddQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
By loading data meaning this is a one time deal or only used to refresh
data stored in the postgresql database???
A possible solution would be to setup a vpn tunnel, or ipsec connection to
server. then run FDW through that connection. Not idea and will slow
things down.
The other option is to use postgresql ODBC on the MSSQL side to pushed from
MSSQL to Postgresql .
On Fri, Jan 10, 2020 at 6:54 AM Soni M <diptatapa(at)gmail(dot)com> wrote:
> Hi All,
> currently I'm trying to configure postgres (on centos) to load data from
> MS SQL server (on windows server) on an encrypted connection.
>
> Trying with tds_fdw, but found that it doesn't support encrypted
> connection.
>
> Is there any solution to this?
>
> Thanks,
>
> Soni.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Israel Brewster | 2020-01-10 17:39:27 | Re: UPDATE many records |
| Previous Message | Adrian Klaver | 2020-01-10 16:26:04 | Re: Encrypted connection SQL server fdw |