From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Mammarelli, Joanne T" <joanne(dot)t(dot)mammarelli(at)verizon(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Best tool to pull from mssql |
Date: | 2015-11-10 19:16:20 |
Message-ID: | 56424284.7020605@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/10/2015 11:13 AM, Mammarelli, Joanne T wrote:
> Are there any type of 'pgadmin' like interfaces for the linux side?
You can use pgAdmin on Windows to look at/manage Postgres servers on any
platform as long as it is reachable. You can also install pgAdmin on
Linux if you desire, but that would be redundant if you are using VM.
>
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: Tuesday, November 10, 2015 2:12 PM
> To: Mammarelli, Joanne T; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com]
>> Sent: Tuesday, November 10, 2015 1:49 PM
>> To: Mammarelli, Joanne T; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com]
>>> Sent: Tuesday, November 10, 2015 1:26 PM
>>> To: Mammarelli, Joanne T; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Susan Hurst | 2015-11-10 20:12:09 | Unexpected Results from regexp_replace |
Previous Message | Mammarelli, Joanne T | 2015-11-10 19:13:07 | Re: Best tool to pull from mssql |