I need to query a specific table that is in MS SQL server using my PostgreSQL 9.3 running in Windows. I did some research and found a FDW that would make it possible (tds_fdw), but the instructions to build it are valid only for linux.
I could build it in a linux dist, but would it work on windows?
If this is not possible, is there any other idea on how to do it? I have full access on both servers and the MS SQL table will need only to be read once a day (and the amount of lines is quite small, so performance is not an issue).
Thanks!