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

From: JingYuan Chen <phil(dot)cyc(at)gmail(dot)com>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org, Juliano <jplinux(at)protonmail(dot)com>
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 12:49:48
Message-ID: CA+7LKP=bwUt7DqN4pGPm6ZHkDyyyhEwWYx0v0FJ93MQf9Q6FRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think that ETL utilities will be the right choice. Try Pentaho's Data
Integration tool. It is Java base.

On Nov 10, 2016 6:45 PM, "Raymond O'Donnell" <rod(at)iol(dot)ie> wrote:

> 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#Speci
> fic_SQL_Database_Wrappers
>
> Not something I've done, but it may be worth a try.
>
> Ray.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2016-11-10 12:56:23 Postgresql 94 from PostgreSQL RPM Repository (with Yum)
Previous 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