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@xxxxxxxxxxxxxx> wrote: > > 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]. > > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
