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 <sco...@openscg.com> wrote: > > On Wed, Nov 11, 2015 at 9:37 AM, taspotts <t_spo...@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 >> > >
