Re: Best tool to pull from mssql

["Elterman, Michael" <melterman@xxxxxxxxx>]

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@xxxxxxxxxxx> wrote:

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