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 Tim Clarke
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 1d9797a9-e467-de18-9239-cf709b4c39cc@manifest.co.uk
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)  (JingYuan Chen <phil.cyc@gmail.com>)
List pgsql-general
Tree view

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@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


		
	


	
	
Attachment

	
	

					

					





	

	pgsql-general by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	Steve Clark

	Date:
	



	Subject:
	Postgresql 94 from PostgreSQL RPM Repository (with Yum)
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	rob stone

	Date:
	



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