Content-Type: multipart/alternative;
	boundary=Apple-Mail-D6D5CE7A-0471-4764-9DE7-478DDD55D9C0
Mime-Version: 1.0 (1.0)
Subject: Re: Oracle to postgres migration
From: John Scalia <jayknowsunix@gmail.com>
In-Reply-To: 
 <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
Date: Mon, 25 Dec 2017 20:51:04 -0500
Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org,
 pgsql-admin@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <7BD67AC6-F903-4A85-8636-2A642537C825@gmail.com>
References: 
 <CAKUuFd6Grtyof7brKu1DcfsxwDYwutUtvp_ezYSc=uRwdX15CQ@mail.gmail.com>
To: Azimuddin Mohammed <azimeiu@gmail.com>
Precedence: bulk


--Apple-Mail-D6D5CE7A-0471-4764-9DE7-478DDD55D9C0
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi,
=20
May I first suggest that you first look at some of EnterpriseDB=E2=80=99s te=
chnical literature. They have some documents which list what their products a=
dd to PostgreSQL to make it more like Oracle. If your firm isn=E2=80=99t doi=
ng this just to get out of licensing fees, they would probably be a good opt=
ion for you. The basics of a migration is to look at the Oracle schema in or=
der to determine which data types you=E2=80=99ll need to convert. Then, you=E2=
=80=99ll need to check which stored procedures you already have, and then wh=
at you=E2=80=99ll need to turn into PostgreSQL functions. Offhand, I=E2=80=99=
d say this isn=E2=80=99t difficult, but it may get very involved.
=E2=80=94
Jay

Sent from my iPad

> On Dec 25, 2017, at 7:30 PM, Azimuddin Mohammed <azimeiu@gmail.com> wrote:=

>=20
> Hello,
> Can anyone guide me through the steps for migration from oracle to postgre=
s with config changes required, keeping in mind that neither I am a oracle D=
BA not postgres admin
>=20
> --=20
>=20
> Regards,
> Azim
>=20
>=20
> 	Virus-free. www.avast.com

--Apple-Mail-D6D5CE7A-0471-4764-9DE7-478DDD55D9C0
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Hi,<div>&nbsp;</div><div>May I first sugges=
t that you first look at some of EnterpriseDB=E2=80=99s technical literature=
. They have some documents which list what their products add to PostgreSQL t=
o make it more like Oracle. If your firm isn=E2=80=99t doing this just to ge=
t out of licensing fees, they would probably be a good option for you. The b=
asics of a migration is to look at the Oracle schema in order to determine w=
hich data types you=E2=80=99ll need to convert. Then, you=E2=80=99ll need to=
 check which stored procedures you already have, and then what you=E2=80=99l=
l need to turn into PostgreSQL functions. Offhand, I=E2=80=99d say this isn=E2=
=80=99t difficult, but it may get very involved.</div><div>=E2=80=94</div><d=
iv>Jay<br><br><div id=3D"AppleMailSignature">Sent from my iPad</div><div><br=
>On Dec 25, 2017, at 7:30 PM, Azimuddin Mohammed &lt;<a href=3D"mailto:azime=
iu@gmail.com">azimeiu@gmail.com</a>&gt; wrote:<br><br></div><blockquote type=
=3D"cite"><div><div dir=3D"ltr">Hello,<div>Can anyone guide me through the s=
teps for migration from oracle to postgres with config changes required, kee=
ping in mind that neither I am a oracle DBA not postgres admin<br clear=3D"a=
ll"><div><br></div>-- <br><div class=3D"gmail_signature" data-smartmail=3D"g=
mail_signature"><div dir=3D"ltr"><br>Regards,<br>Azim<br><br></div></div>
</div></div><div id=3D"DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style=3D"border-top:1px solid #d3d4de">
	<tbody><tr>
        <td style=3D"width:55px;padding-top:13px"><a href=3D"https://www.ava=
st.com/sig-email?utm_medium=3Demail&amp;utm_source=3Dlink&amp;utm_campaign=3D=
sig-email&amp;utm_content=3Dwebmail&amp;utm_term=3Dicon" target=3D"_blank"><=
img src=3D"https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-or=
ange-animated-no-repeat-v1.gif" alt=3D"" width=3D"46" height=3D"29" style=3D=
"width: 46px; height: 29px;"></a></td>
		<td style=3D"width:470px;padding-top:12px;color:#41424e;fon=
t-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-f=
ree. <a href=3D"https://www.avast.com/sig-email?utm_medium=3Demail&amp;utm_s=
ource=3Dlink&amp;utm_campaign=3Dsig-email&amp;utm_content=3Dwebmail&amp;utm_=
term=3Dlink" target=3D"_blank" style=3D"color:#4453ea">www.avast.com</a>
		</td>
	</tr>
</tbody></table><a href=3D"#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width=3D"1=
" height=3D"1"></a></div>
</div></blockquote></div></body></html>=

--Apple-Mail-D6D5CE7A-0471-4764-9DE7-478DDD55D9C0--