Re: Best tool to pull from mssql
От | Mammarelli, Joanne T |
---|---|
Тема | Re: Best tool to pull from mssql |
Дата | |
Msg-id | 2A9DC32516465540A0B1D37D25D6EF9A04149BEDD4@FHDP1LUMXC7V12.us.one.verizon.com обсуждение исходный текст |
Ответ на | Re: Best tool to pull from mssql (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: Best tool to pull from mssql
(Adrian Klaver <adrian.klaver@aklaver.com>)
|
Список | pgsql-general |
Are there any type of 'pgadmin' like interfaces for the linux side? -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@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.klaver@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 outthe 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 Ican 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 isinstalled 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@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.klaver@aklaver.com >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: