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

[Juliano <jplinux@xxxxxxxxxxxxxx>]

Hi,

 

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

 

Postgresql 9.6 encoding is utf-8 and does not support utf-16 but, I need to transfer this data to postgres.

 

I also tried to use tds_fdw version 1.0.8 and the same problem occurs.

 

ERROR: DB-Library error: DB #: 100, DB Msg: TDS version downgraded to 7.1!, OS #: 0, OS Msg: Success, Level: 1

 

********** Error **********

 

ERROR: DB-Library error: DB #: 100, DB Msg: TDS version downgraded to 7.1!, OS #: 0, OS Msg: Success, Level: 1

SQL state: HV00L

 

Please help me.