agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Timo Myyrä <timo.myyra@bittivirhe.fi>
To: pgsql-general@lists.postgresql.org
Subject: Re: Oracle to postgres migration
Date: Tue, 26 Dec 2017 14:32:38 +0200
Message-ID: <1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com> (raw)
In-Reply-To: <8700DEEF-606B-47EF-8EA3-D95CE1B66EA6@gmail.com>
References: <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
<8700DEEF-606B-47EF-8EA3-D95CE1B66EA6@gmail.com>
On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote:
> I'd start with this first : https://ora2pg.darold.net
>
>> On 26 Dec 2017, at 02:30, Azimuddin Mohammed
>> <azimeiu@gmail.com> wrote:>>
>> Hello,
>> Can anyone guide me through the steps for migration from oracle to
>> postgres with config changes required, keeping in mind that neither I
>> am a oracle DBA not postgres admin>>
>> --
>>
>> Regards,
>> Azim
>>
>>
>> Virus-free. www.avast.com[1]
I second the ora2pg tool. Currently working on oracle to postgresql
migration with it and ora2pg helps a lot.But you can't get ready recipe for migration. There's ton of stuff to
consider from trivial rewriting NVL queries to use COALESCE to more
bigger stuff like lack of synonyms in postgresql. All depends on your
current Oracle database.
Timo
Links:
1. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...
view thread (5+ messages) latest in thread
Message-ID: <1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com>
Permalink: ../1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com/
Also on: postgresql.org/message-id/1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: timo.myyra@bittivirhe.fi, pgsql-general@lists.postgresql.org
Subject: Re: Oracle to postgres migration
In-Reply-To: <1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox