Postgres Pro
Downloads
Home   >   mailing lists

Re: 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 Raymond O'Donnell
Subject Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)
Date
Msg-id f906c3cf-21eb-0651-25a1-0edf86bd1a37@iol.ie
Whole thread Raw
In response to Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)  (Juliano <jplinux@protonmail.com>)
Responses Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)  (JingYuan Chen <phil.cyc@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

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