Are there any type of 'pgadmin' like interfaces for the linux side? -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Tuesday, November 10, 2015 2:12 PM To: Mammarelli, Joanne T; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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.klaver@xxxxxxxxxxx] > Sent: Tuesday, November 10, 2015 1:49 PM > To: Mammarelli, Joanne T; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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.klaver@xxxxxxxxxxx] >> Sent: Tuesday, November 10, 2015 1:26 PM >> To: Mammarelli, Joanne T; pgsql-general@xxxxxxxxxxxxxx >> Subject: Re: 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.klaver@xxxxxxxxxxx >> > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx > -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
