Re: dblink_tds or similar for PostgreSQL 10

Hi.

I know that Postgres 10 is not yet stable. The migration will take
around 3 or 4 months. I will expect by then, the stable version.
I've reading about FDW and tds_fdw (library for MS SQL), but it says:
"The current version does not yet support WHERE clause push-down,
column push-down, JOIN push-down, or write operations."
Sadly, I need to do a INSERT on MS SQL.

Thanks.
Carlos Martinez

On Wed, Sep 27, 2017 at 8:57 AM, Fabrízio de Royes Mello
<fabrizio(at)timbira(dot)com(dot)br> wrote:
>
> 2017-09-27 4:02 GMT-03:00 Carlos Martinez <camarti(at)gmail(dot)com>:
>>
>> Hi.
>>
>> I need to migrate a database from Postgres 9.0 to Postgres 10.
>>
>
> Be careful because version 10 "stable" isn't released yet.
>
>
>> On pg9 we use dblink_tds to connect to a Ms SQL Server to do a simple
>> INSERT and a simple SELECT.
>>
>> So, there is an alternative in pg10 similar to dblink_tds for make
>> SELECTs and INSERTs on MS SQL?
>>
>> If not, what do yo recommend me?
>>
>
> I think dblink_tds is deprecated for a long time... for now we recommend use
> Foreign Data Wrappers [1] and in your case tds_fdw [2].
>
> Regards,
>
> [1] https://wiki.postgresql.org/wiki/Foreign_data_wrappers
> [2] https://pgxn.org/dist/tds_fdw/
>
> --
> Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento