2017-09-27 4:02 GMT-03:00 Carlos Martinez <camarti@xxxxxxxxx>:
>
> 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].
[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
> 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
