Postgres Pro
Downloads
Home   >   mailing lists

Re: Best tool to pull from mssql - Mailing list pgsql-general

From Elterman, Michael
Subject Re: Best tool to pull from mssql
Date
Msg-id CACoOY7a98WY49mRGkSSbmQ9B7G9oPjd33_2+jkmaivxosJ6DJQ@mail.gmail.com
Whole thread Raw
In response to Re: Best tool to pull from mssql  (Scott Mead <scottm@openscg.com>)
List pgsql-general
Tree view
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  
or Devart ODBC driver

On Wed, Nov 11, 2015 at 9:27 AM, Scott Mead <scottm@openscg.com> wrote:

On Wed, Nov 11, 2015 at 9:37 AM, taspotts <t_spotts@tcdi.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Best tool to pull from mssql
Next
From: Geoff Montee
Date:
Subject: Re: attempting to install tds_fw-master on redhat