agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: John Scalia <jayknowsunix@gmail.com>
To: Azimuddin Mohammed <azimeiu@gmail.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to postgres migration
Date: Mon, 25 Dec 2017 20:51:04 -0500
Message-ID: <7BD67AC6-F903-4A85-8636-2A642537C825@gmail.com> (raw)
In-Reply-To: <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
References: <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
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
view thread (5+ messages) latest in thread
Message-ID: <7BD67AC6-F903-4A85-8636-2A642537C825@gmail.com>
Permalink: ../7BD67AC6-F903-4A85-8636-2A642537C825@gmail.com/
Also on: postgresql.org/message-id/7BD67AC6-F903-4A85-8636-2A642537C825@gmail.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: jayknowsunix@gmail.com, azimeiu@gmail.com, pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: Oracle to postgres migration
In-Reply-To: <7BD67AC6-F903-4A85-8636-2A642537C825@gmail.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