Are there any type of 'pgadmin' like interfaces for the linux side?
-----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/2015 11:06 AM, Mammarelli, Joanne T wrote: > 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/ Another option would be to install 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 > > 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-acces > s-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:adrian.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 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 >> adrian.kla...@aklaver.com >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
