Re: tds_fdw - work on windows

On 11/10/2015 07:37 AM, Mammarelli, Joanne T wrote:
> Are there any options for linking a Microsoft sql database to a postgresql database?
>
> (I want the postgresql database to be the "puller")

How did you install Postgres on the Windows machine?

If through the graphical installer from EDB, you might want to to see if
tds_fdw is offered through the Stack Builder?

>
>
>
> -----Original Message-----
> From: Jim Nasby [mailto:Jim(dot)Nasby(at)BlueTreble(dot)com]
> Sent: Tuesday, November 10, 2015 10:21 AM
> To: Mammarelli, Joanne T; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] tds_fdw - work on windows
>
> On 11/10/15 7:57 AM, Mammarelli, Joanne T wrote:
>> Hi - rookie user here.
>>
>> I'd like to access data on my Microsoft sql database from my postgres
>> database.
>>
>> I stumbled upon the tds_fdw extension and it reads as if it it's *nix only.
>>
>> Would acquiring tds_fdw.control from one of the repos possibly work on
>> a windows-based postgres installed database?
>
> Building source code on windows is radically different than doing so on unix, so no. The only thing that might work is setting up a cygwin environment and seeing if it will build in that.
>
> BTW, if you want to get an easier introduction to using unix than switching to an actual linux/unix get a Mac. The command line is unix.
> --
> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com