Postgres Pro
Downloads
Home   >   mailing lists

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

From Juliano
Subject Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Date
Msg-id bJkVbjssxqTQaXlGXyKuRbuozh2DxsJhamIT2vnctB-dFn59qPaSmHjuCRQ7s7xUMlj-kpbXGFlEfp2jbBWXwBA9zmKQP895yrhGErVpbLs=@protonmail.com
Whole thread Raw
Responses 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)  (rob stone <floriparob@gmail.com>)
List pgsql-general
Tree view

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.


pgsql-general by date:

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