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@xxxxxxxxxxxxxx> · Thu, 10 Nov 2016 13:20:59 +0000



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