Re: dump to pg

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: vinny <vinny(at)xs4all(dot)nl>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>, pgsql-general-owner(at)postgresql(dot)org
Subject: Re: dump to pg
Date: 2017-06-01 21:21:01
Message-ID: CA+ssMOQ==3ymwuoecmR4gF2b42SwoKzyuKHizMbonZvXhAtzYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks all,

The point is I only have access to dump files, no ora/mssql server instance
access. I have noticed the warning around legality on that question. The
best solution for me is to ask to each. Once get answer, I will come back
here to provide the answer.

2017-06-01 4:14 GMT-04:00 vinny <vinny(at)xs4all(dot)nl>:

> On 2017-05-31 16:43, Nicolas Paris wrote:
>
>> Hi,
>>
>> I have dumps from oracle and microsoft sql server (no more details).
>> Is it possible to load them "directly" into postgres (without
>> oracle/mssql license)?
>>
>> dump -> csv -> postgtres
>>
>> or something ?
>>
>> Thanks a lot
>>
>
> A very, *very* short trip to google shows that "intelligent converters"
> have tools that can do both:
>
> https://www.convert-in.com/ora2pgs.htm
>
> There is a trial version with limited options, and the full version seems
> to be priced at $49 to $100.
>
> Disclaimer: I have no experience with this company or it's products, I'm
> not affiliated, I just googled
> and copy/pasted the result.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2017-06-01 21:33:11 Re: dump to pg
Previous Message Karl Czajkowski 2017-06-01 20:44:17 Re: jsonb case insensitive search