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 .
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.