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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Juliano <jplinux(at)protonmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 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:44:16
Message-ID: f906c3cf-21eb-0651-25a1-0edf86bd1a37@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message otar shavadze 2016-11-10 12:41:22 Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists
Previous Message Juliano 2016-11-10 10:34:52 Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)