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 JingYuan Chen
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 CA+7LKP=bwUt7DqN4pGPm6ZHkDyyyhEwWYx0v0FJ93MQf9Q6FRA@mail.gmail.com
Whole thread Raw
In response to 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>)
Responses Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)  (Tim Clarke <tim.clarke@manifest.co.uk>)
List pgsql-general
Tree view

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@iol.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#Specific_SQL_Database_Wrappers

Not something I've done, but it may be worth a try.

Ray.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: otar shavadze
Date:
Subject: Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists
Next
From: Steve Clark
Date:
Subject: Postgresql 94 from PostgreSQL RPM Repository (with Yum)