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

I'd recommend Talend, they have an open source edition that we use. Very powerful and reliable.

Tim Clarke

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