I updated odbc drivers and it worked.
Thanks everyone
Regards,
Juliano
Sent with [ProtonMail](https://protonmail.com) Secure Email.
Original Message
Subject: Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6
using dbi-link and fdw (error: utf-8/uft-16
On Thu, 2016-11-10 at 05:34 -0500, Juliano wrote:
> Hi,
>
> I'm trying to import some data from a MS SQL Server 2014 sequential
> database to Postgresql using dbi-link.
>
> Postgresql 9.6 encoding is utf-8 and does not support utf-16 but, I
> need to transfer this data to postgres.
>
> I als
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, "Raym
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" 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
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
On 7 Jun 2006 05:13:15 -0700, Daniel <[EMAIL PROTECTED]> wrote:
Hi..
Im Daniel and need soem help in importing data from MS SQL Server
to Postgresql DB. Is there a bulit in option for importing from
Postgresql? Help me out!!
as others suggest, you definately want to go 'dts' on anything
Daniel wrote:
Hi..
Im Daniel and need soem help in importing data from MS SQL Server
to Postgresql DB. Is there a bulit in option for importing from
Postgresql? Help me out!!
Regards,
Daniel.
---(end of broadcast)---
TIP 5: don't forget to
You can use the DTS of SQL Server and there use the ODBC driver for PostgreSQL for making a connection to the target PostgreSQL database./ShoaibOn 7 Jun 2006 05:13:15 -0700,
Daniel <[EMAIL PROTECTED]> wrote:
Hi.. Im Daniel and need soem help in importing data from MS SQL Serverto Postgresql D
> Hi..
> Im Daniel and need soem help in importing data from MS
> SQL Server to Postgresql DB. Is there a bulit in option for
> importing from Postgresql? Help me out!!
You can easily use the DTS tool in SQL Server to export data to
PostgreSQL through the ODBC driver.
//Magnus
--
