| From: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: dblink_tds or similar for PostgreSQL 10 |
| Date: | 2017-09-27 13:57:56 |
| Message-ID: | CAPfkCSBT4ACO-oHvbkxcr6sG1EkhNe0c+XRH7OjzMwacr3Jzhg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Martinez | 2017-09-27 14:45:22 | Re: dblink_tds or similar for PostgreSQL 10 |
| Previous Message | Carlos Martinez | 2017-09-27 07:02:27 | dblink_tds or similar for PostgreSQL 10 |