Are there any options for linking a Microsoft sql database to a postgresql database?
(I want the postgresql database to be the "puller")
-----Original Message-----
From: Jim Nasby [mailto:Jim.Nasby@BlueTreble.com]
Sent: Tuesday, November 10, 2015 10:21 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.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
settingup 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
commandline is unix.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL
Datain Trouble? Get it in Treble! http://BlueTreble.com