Re: Best tool to pull from mssql

SSIS can be used to migrate data from MSSQL to Postgres and back.
It is native for MS SQL
You can use PG ODBC driver
http://www.postgresql.org/ftp/odbc/versions/msi/
or Devart ODBC driver
https://www.devart.com/odbc/postgresql/

On Wed, Nov 11, 2015 at 9:27 AM, Scott Mead <scottm(at)openscg(dot)com> wrote:

>
> On Wed, Nov 11, 2015 at 9:37 AM, taspotts <t_spotts(at)tcdi(dot)com> wrote:
>
>> Take a look at Pentaho Kettle
>> <http://community.pentaho.com/projects/data-integration/> . They have a
>> free community edition.
>>
>>
> +10
>
>
>> I use it frequently to migrate data from MSSQL to Postgres. It has a nice
>> GUI for setting everything up and the transforms/jobs can be scheduled.
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://postgresql.nabble.com/Best-tool-to-pull-from-mssql-tp5873415p5873509.html
>> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>