agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedOracle to postgres migration
5+ messages / 4 participants
[nested] [flat]
* Oracle to postgres migration
@ 2017-12-26 00:30 Azimuddin Mohammed <azimeiu@gmail.com>
0 siblings, 3 replies; 5+ messages in thread
From: Azimuddin Mohammed @ 2017-12-26 00:30 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-sql; pgsql-admin@postgresql.org
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
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...;
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...;
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle to postgres migration
@ 2017-12-26 01:51 John Scalia <jayknowsunix@gmail.com>
parent: Azimuddin Mohammed <azimeiu@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: John Scalia @ 2017-12-26 01:51 UTC (permalink / raw)
To: Azimuddin Mohammed <azimeiu@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql; pgsql-admin@postgresql.org
Hi,
May I first suggest that you first look at some of EnterpriseDB’s technical literature. They have some documents which list what their products add to PostgreSQL to make it more like Oracle. If your firm isn’t doing this just to get out of licensing fees, they would probably be a good option for you. The basics of a migration is to look at the Oracle schema in order to determine which data types you’ll need to convert. Then, you’ll need to check which stored procedures you already have, and then what you’ll need to turn into PostgreSQL functions. Offhand, I’d say this isn’t difficult, but it may get very involved.
—
Jay
Sent from my iPad
> On Dec 25, 2017, at 7:30 PM, 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle to postgres migration
@ 2017-12-26 09:36 Vasilis Ventirozos <v.ventirozos@gmail.com>
parent: Azimuddin Mohammed <azimeiu@gmail.com>
2 siblings, 1 reply; 5+ messages in thread
From: Vasilis Ventirozos @ 2017-12-26 09:36 UTC (permalink / raw)
To: Azimuddin Mohammed <azimeiu@gmail.com>; +Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org, pgsql-admin <pgsql-admin@postgresql.org>
I'd start with this first : https://ora2pg.darold.net <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
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...; Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...; <x-msg://28/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle to postgres migration
@ 2017-12-26 12:32 Timo Myyrä <timo.myyra@bittivirhe.fi>
parent: Vasilis Ventirozos <v.ventirozos@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Timo Myyrä @ 2017-12-26 12:32 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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&...
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle to postgres migration
@ 2017-12-26 13:14 Timo Myyrä <timo.myyra@bittivirhe.fi>
parent: Azimuddin Mohammed <azimeiu@gmail.com>
2 siblings, 0 replies; 5+ messages in thread
From: Timo Myyrä @ 2017-12-26 13:14 UTC (permalink / raw)
To: Azimuddin Mohammed <azimeiu@gmail.com>; pgsql-general@postgresql.org; pgsql-sql; pgsql-admin@postgresql.org
On Tue, Dec 26, 2017, at 02:30, Azimuddin Mohammed 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]
You should read this through before starting the migration process.
https://ora2pg.darold.net/slides/ora2pg_the_hard_way.pdf
Timo
Links:
1. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&...
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-12-26 13:14 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-12-26 00:30 Oracle to postgres migration Azimuddin Mohammed <azimeiu@gmail.com>
2017-12-26 01:51 ` John Scalia <jayknowsunix@gmail.com>
2017-12-26 09:36 ` Vasilis Ventirozos <v.ventirozos@gmail.com>
2017-12-26 12:32 ` Timo Myyrä <timo.myyra@bittivirhe.fi>
2017-12-26 13:14 ` Timo Myyrä <timo.myyra@bittivirhe.fi>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox