Thank you Geoff. Actually I have a problem - maybe you can point me in the right direction? CREATE EXTENSION tds_fdw; CREATE EXTENSION CREATE SERVER ms FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'ms'); CREATE SERVER CREATE USER MAPPING FOR postgres SERVER ms OPTIONS (username 'bzzt', password 'blurp'); CREATE USER MAPPING CREATE FOREIGN TABLE test ( id integer ) SERVER ms OPTIONS ( database 'MyApp', query 'select 1' ); CREATE FOREIGN TABLE SELECT * FROM test; NOTICE: DB-Library notice: Msg #: 5701, Msg state: 2, Msg: Changed database context to 'master'., Server: ms, Process: , Line: 1, Level: 0 NOTICE: DB-Library notice: Msg #: 5703, Msg state: 1, Msg: Changed language setting to us_english., Server: ms, Process: , Line: 1, Level: 0 NOTICE: DB-Library notice: Msg #: 40508, Msg state: 1, Msg: USE statement is not supported to switch between databases. Use a new connection to connect to a different database., Server: ms, Process: , Line: 1, Level: 16 ERROR: DB-Library error: DB #: 40508, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: (null), Level: 16 Thanks, Filip On Mon, May 18, 2015 at 6:23 PM, Geoff Montee <geoff.montee@xxxxxxxxx> wrote: > Hi Filip, > > On Mon, May 18, 2015 at 7:52 AM, Filip Rembiałkowski > <filip.rembialkowski@xxxxxxxxx> wrote: >> Hi. >> >> I will be happy to hear your opinion which one is better - odbc_fdw or tds_fdw? >> >> In terms of performance / stability / convenience. >> >> (Pg on OpenSuse, MS SQL on Win2008 ) >> >> Thanks! >> > > I'm the developer of tds_fdw. I originally developed tds_fdw because I > wasn't able to get odbc_fdw working with FreeTDS. If you try out > odbc_fdw, hopefully you'll have better luck than I did! > > If you decide to try out tds_fdw and you have any problems or run into > any bugs, feel free to ask for help on the GitHub page: > > https://github.com/GeoffMontee/tds_fdw > > Good luck! > > Thanks, > > Geoff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
