Thanks - I've been dying trying to find the software (on the windows side) for part 3 ..
https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration--part-3/ -----Original Message----- From: Adrian Klaver [mailto:[email protected]] Sent: Tuesday, November 10, 2015 1:49 PM To: Mammarelli, Joanne T; [email protected] 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 > connect to the mssql databases and pull out the fields/content we required > and populate that in a postgres database. When all else fails you can go the ODBC route. I have done that through Access to create a linked Postgres table that I can populate from other data sources. Here are some articles that seem to be doing something similar using SQL Server and Postgres. In the article Postgres is installed on a Linux box, but that does matter for the ODBC usage. : https://www.mssqltips.com/sqlservertip/3661/creating-twoway-data-access-between-sql-server-and-postgresql--part-1/ https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration--part-2/ > > > -----Original Message----- > From: Adrian Klaver [mailto:[email protected]] > Sent: Tuesday, November 10, 2015 1:26 PM > To: Mammarelli, Joanne T; [email protected] > 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 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 syncing or > something in between? > >> >> Is this the proper way to handle the process? >> > > Depends on the answer to the above. > > > -- > Adrian Klaver > [email protected] > -- Adrian Klaver [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
