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