Re: [ADMIN] dblink_tds or similar for PostgreSQL 10
| От | Fabrízio de Royes Mello |
|---|---|
| Тема | Re: [ADMIN] dblink_tds or similar for PostgreSQL 10 |
| Дата | |
| Msg-id | CAPfkCSBT4ACO-oHvbkxcr6sG1EkhNe0c+XRH7OjzMwacr3Jzhg@mail.gmail.com обсуждение исходный текст |
| Ответ на | [ADMIN] dblink_tds or similar for PostgreSQL 10 (Carlos Martinez <camarti@gmail.com>) |
| Ответы |
Re: [ADMIN] dblink_tds or similar for PostgreSQL 10
|
| Список | pgsql-admin |
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].
[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
В списке pgsql-admin по дате отправления: