Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)

Поиск
Список
Период
Сортировка
От JingYuan Chen
Тема Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Дата
Msg-id CA+7LKP=bwUt7DqN4pGPm6ZHkDyyyhEwWYx0v0FJ93MQf9Q6FRA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)  (Raymond O'Donnell <rod@iol.ie>)
Ответы Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)  (Tim Clarke <tim.clarke@manifest.co.uk>)
Список pgsql-general
Дерево обсуждения

I think that ETL utilities will be the right choice. Try Pentaho's Data Integration tool. It is Java base.


On Nov 10, 2016 6:45 PM, "Raymond O'Donnell" <rod@iol.ie> wrote:
On 10/11/16 10:34, Juliano wrote:
Hi,



I'm trying to import some data from a MS SQL Server 2014 sequential
database to Postgresql using dbi-link.

Have you tried the foreign data wrapper for MS SQL Server? It's here:

https://wiki.postgresql.org/wiki/Foreign_data_wrappers#Specific_SQL_Database_Wrappers

Not something I've done, but it may be worth a try.

Ray.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: otar shavadze
Дата:
Сообщение: Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists
Следующее
От: Steve Clark
Дата:
Сообщение: Postgresql 94 from PostgreSQL RPM Repository (with Yum)