Re: [GENERAL] Best tool to pull from mssql

On Tue, Nov 10, 2015 at 12:26 PM, Adrian Klaver wrote: > On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote: >> >> Hi .. we’re on a hunt to locate either pgloader or the tds_fdw extension >> to assist us with pulling data FROM a Microsoft sql server (we’re a >> windows-based postgres installation)

Re: [GENERAL] 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 wrote: > > On Wed, Nov 1

Re: [GENERAL] Best tool to pull from mssql

On Wed, Nov 11, 2015 at 9:37 AM, taspotts wrote: > Take a look at Pentaho Kettle > . 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 everythi

Re: [GENERAL] Best tool to pull from mssql

Take a look at Pentaho Kettle . They have a free community edition. 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 mes

Re: [GENERAL] Best tool to pull from mssql

, but that would be redundant if you are using VM. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, November 10, 2015 2:12 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql On 11/10/201

Re: [GENERAL] Best tool to pull from mssql

ltips.com/sqlservertip/3662/sql-server-and-postgresql- > linked-server-configuration--part-2/ >> >> >> -Original Message- >> From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] >> Sent: Tuesday, November 10, 2015 1:26 PM >> To: Mammarelli, Joanne T; pgsql

Re: [GENERAL] Best tool to pull from mssql

stall the Postgres server in a Linux VM on your Windows machine. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, November 10, 2015 1:49 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql

Re: [GENERAL] Best tool to pull from mssql

Sent: Tuesday, November 10, 2015 1:49 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql On 11/10/2015 10:26 AM, Mammarelli, Joanne T wrote: > Continuously syncing .. we have database in mssql. Ideally we'd like to > conn

Re: [GENERAL] Best tool to pull from mssql

n.kla...@aklaver.com] Sent: Tuesday, November 10, 2015 1:26 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote: Hi .. we're on a hunt to locate either pgloader or the tds_fdw extension

Re: [GENERAL] Best tool to pull from mssql

esday, November 10, 2015 1:26 PM To: Mammarelli, Joanne T; pgsql-general@postgresql.org Subject: Re: [GENERAL] Best tool to pull from mssql On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote: > Hi .. we're on a hunt to locate either pgloader or the tds_fdw > extension to assist us with pul

Re: [GENERAL] Best tool to pull from mssql

On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote: Hi .. we’re on a hunt to locate either pgloader or the tds_fdw extension to assist us with pulling data FROM a Microsoft sql server (we’re a windows-based postgres installation). So are we taking about a one time operation or continuously sync

[GENERAL] Best tool to pull from mssql

Hi .. we're on a hunt to locate either pgloader or the tds_fdw extension to assist us with pulling data FROM a Microsoft sql server (we're a windows-based postgres installation). Is this the proper way to handle the process?