From: | "Elterman, Michael" <melterman(at)enova(dot)com> |
---|---|
To: | Scott Mead <scottm(at)openscg(dot)com> |
Cc: | taspotts <t_spotts(at)tcdi(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Best tool to pull from mssql |
Date: | 2015-11-11 16:43:40 |
Message-ID: | CACoOY7a98WY49mRGkSSbmQ9B7G9oPjd33_2+jkmaivxosJ6DJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Montee | 2015-11-11 18:55:00 | Re: attempting to install tds_fw-master on redhat |
Previous Message | Scott Mead | 2015-11-11 15:27:39 | Re: Best tool to pull from mssql |