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

On 10/11/16 12:49, JingYuan Chen wrote:
>
> 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(at)iol(dot)ie
> <mailto:rod(at)iol(dot)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
> <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(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> <http://www.postgresql.org/mailpref/pgsql-general>
>