Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'd recommend Talend, they have an open source edition that we use. Very powerful and reliable.


Tim Clarke


    
On 10/11/16 12:49, JingYuan Chen wrote:

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@xxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

<<attachment: smime.p7s>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux