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

From: Juliano <jplinux(at)protonmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Date: 2016-11-10 10:34:52
Message-ID: bJkVbjssxqTQaXlGXyKuRbuozh2DxsJhamIT2vnctB-dFn59qPaSmHjuCRQ7s7xUMlj-kpbXGFlEfp2jbBWXwBA9zmKQP895yrhGErVpbLs=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2016-11-10 10:44:16 Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Previous Message Samuel Williams 2016-11-10 09:59:49 Re: initdb createuser commands