MIME-Version: 1.0
References: 
 <CAN6TVjmHpfJ+Q_HJcnrNUoDNghwkQ5WKVL_gh4iBTUzOhAG=1Q@mail.gmail.com>
 <CAHYHq4Vpr=G0CWA7nKS4JETXYGCs3KJEebDriii-jXEN+RFJtQ@mail.gmail.com>
In-Reply-To: 
 <CAHYHq4Vpr=G0CWA7nKS4JETXYGCs3KJEebDriii-jXEN+RFJtQ@mail.gmail.com>
From: ji hwan song <song7357@gmail.com>
Date: Fri, 12 Jul 2024 22:13:34 +0900
Message-ID: 
 <CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w@mail.gmail.com>
Subject: Re: Oracle to Postgres
To: Muhammad Waqas <waqas.m@bitnine.net>
Cc: Sam Stearns <sam.stearns@dat.com>, pgsql-admin@lists.postgresql.org,
	Catherine Schulz <catherine.schulz@dat.com>,
 Peter Garza <peter.garza@dat.com>,
	Henry Ashu <henry.ashu@dat.com>
Content-Type: multipart/alternative; boundary="00000000000047127e061d0ca63a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHTrd785mvmau50pfh_BVSyO2FPbaaFNRvBGdU3tm6rJcNff5w%40mail.gmail.com>
Precedence: bulk

--00000000000047127e061d0ca63a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: base64

7KCA64qUIO2VnOq1reydmCAyMOuFhOywqCBkYmEg7J6F64uI64ukLiAg7ZiE7J6sIG9yYWNsZSAv
dGliZXJvICBkYiAsIHBvZHN0Z3JlcywvZWRiL215c3FsIC9tYXJpYWRiDQosIOyEnOuhnCBtaWdy
YXRpb24g7ZWg7IiYIOyeiOuKlCBqYXZhIOuQnCDtlITroZzqt7jrnqgg66eM65Ok7JeI7Iq164uI
64ukLg0KIOq4sOuKpeydgCBzb3VyY2UgZGIg7JmAIHRhcmdldGRiIOydmCDsiqTtgqTrp4gg7Jew
64+ZICggdGFibGXsg53shLEgLHBrIOyZgCBwayBpbmRleCDsnpDrj5kg7IOd7ISxIOq4sOuKpSAg
LA0Kc291cmNlIGRiIHRhcmdldCBkYiAgZGF0YSBtaWdyYXRpb24gIOq4sOuKpSDquYzsp4Ag6rCA
64qlIO2VqeuLiOuLpC4NCiDslYTsp4HquYzsp4DripQg64uk7JaR7ZWcIOyKpO2CpOuniOuhnCDt
hYzsiqTtirgg7JWI65CY7JeI7Iq164uI64ukLiDsoIDsl5Dqsowgb3JhY2xlIDExIOuyhOyghCBk
dW1wIO2MjOydvOydhCDrs7TrgrTso7zsi5zrqbQg7YWM7Iqk7Yq4IO2VtOuztOqzoCDshozsiqQg
7KCc6rO17ZW0DQrrk5zrpqzqsqDsirXri4jri6QuDQoNCjIwMjTrhYQgN+yblCAxMuydvCAo6riI
KSDsmKTtm4QgODozOSwgTXVoYW1tYWQgV2FxYXMgPHdhcWFzLm1AYml0bmluZS5uZXQ+64uY7J20
IOyekeyEsToNCg0KPiBvcmEycGcgZm9yIG9iamVjdCBtaWdyYXRpb24NCj4gc3FsbGluZXMgZm9y
IGRhdGEgbWlncmF0aW9uDQo+DQo+IGFib3ZlIHRvb2xzIGFyZSB0ZXN0ZWQNCj4NCj4gMjAyNOuF
hCA37JuUIDEy7J28ICjquIgpIOyYpOyghCA1OjAyLCBTYW0gU3RlYXJucyA8c2FtLnN0ZWFybnNA
ZGF0LmNvbT7ri5jsnbQg7J6R7ISxOg0KPg0KPj4gSG93ZHksDQo+Pg0KPj4gV2UgaGF2ZSBhIHBy
b2plY3QgdG8gbWlncmF0ZSBvdXIgT3JhY2xlIGRhdGFiYXNlcyB0aGF0IGFyZSBob3N0ZWQgb24g
YW4NCj4+IE9yYWNsZSBEYXRhYmFzZSBBcHBsaWFuY2UgdG8gUG9zdGdyZXMgaG9zdGVkIG9uIGEg
TGludXggVk0uICBRdWVzdGlvbnM6DQo+Pg0KPj4NCj4+ICAgIDEuIElzIHRoZXJlIGEgdG9vbCBv
dXQgdGhlcmUgdGhhdCB3ZSBjYW4gdXNlIHRvIGFuYWx5emUgcmVzb3VyY2UNCj4+ICAgIHNpemlu
ZyBvbiB0aGUgQXBwbGlhbmNlIHRoYXQgd2lsbCBnaXZlIHJlc291cmNlIHNpemluZyByZWNvbW1l
bmRhdGlvbnMgZm9yDQo+PiAgICB0aGUgVk0/DQo+PiAgICAyLiBJcyB0aGVyZSBhIHNjaGVtYSBj
b252ZXJzaW9uIHRvb2wgb3Igc2ltaWxhciBvdXQgdGhlcmUgdGhhdCB3ZSBjYW4NCj4+ICAgIHVz
ZSB0byBjb252ZXJ0IE9yYWNsZSA9PT4gUG9zdGdyZXM/DQo+Pg0KPj4gVGhhbmtzLA0KPj4NCj4+
IFNhbQ0KPj4NCj4+IC0tDQo+Pg0KPj4gKlNhbXVlbCBTdGVhcm5zKg0KPj4gTGVhZCBEYXRhYmFz
ZSBBZG1pbmlzdHJhdG9yDQo+PiAqYzoqIDk3MSA3NjIgNjg3OSB8ICpvOiogNTAzIDY3MiA1MTE1
IHwgREFULmNvbQ0KPj4gW2ltYWdlOiBEQVRdDQo+PiA8aHR0cHM6Ly93d3cuZGF0LmNvbS8/dXRt
X21lZGl1bT1lbWFpbCZ1dG1fc291cmNlPURBVF9lbWFpbF9zaWduYXR1cmVfbGluaz4NCj4+DQo+
DQo=
--00000000000047127e061d0ca63a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">=EC=A0=80=EB=8A=94 =ED=95=9C=EA=B5=AD=EC=9D=98 20=EB=85=84=
=EC=B0=A8 dba =EC=9E=85=EB=8B=88=EB=8B=A4.=C2=A0 =ED=98=84=EC=9E=AC oracle =
/tibero=C2=A0 db , podstgres,/edb/mysql /mariadb , =EC=84=9C=EB=A1=9C migra=
tion =ED=95=A0=EC=88=98 =EC=9E=88=EB=8A=94 java =EB=90=9C =ED=94=84=EB=A1=
=9C=EA=B7=B8=EB=9E=A8 =EB=A7=8C=EB=93=A4=EC=97=88=EC=8A=B5=EB=8B=88=EB=8B=
=A4.=C2=A0<div>=C2=A0=EA=B8=B0=EB=8A=A5=EC=9D=80 source db =EC=99=80 target=
db =EC=9D=98 =EC=8A=A4=ED=82=A4=EB=A7=88 =EC=97=B0=EB=8F=99 ( table=EC=83=
=9D=EC=84=B1 ,pk =EC=99=80 pk index =EC=9E=90=EB=8F=99 =EC=83=9D=EC=84=B1 =
=EA=B8=B0=EB=8A=A5=C2=A0 , source db target db=C2=A0=C2=A0data migration=C2=
=A0 =EA=B8=B0=EB=8A=A5 =EA=B9=8C=EC=A7=80 =EA=B0=80=EB=8A=A5 =ED=95=A9=EB=
=8B=88=EB=8B=A4.=C2=A0</div><div>=C2=A0=EC=95=84=EC=A7=81=EA=B9=8C=EC=A7=80=
=EB=8A=94 =EB=8B=A4=EC=96=91=ED=95=9C =EC=8A=A4=ED=82=A4=EB=A7=88=EB=A1=9C =
=ED=85=8C=EC=8A=A4=ED=8A=B8 =EC=95=88=EB=90=98=EC=97=88=EC=8A=B5=EB=8B=88=
=EB=8B=A4. =EC=A0=80=EC=97=90=EA=B2=8C oracle 11 =EB=B2=84=EC=A0=84 dump =
=ED=8C=8C=EC=9D=BC=EC=9D=84 =EB=B3=B4=EB=82=B4=EC=A3=BC=EC=8B=9C=EB=A9=B4 =
=ED=85=8C=EC=8A=A4=ED=8A=B8 =ED=95=B4=EB=B3=B4=EA=B3=A0 =EC=86=8C=EC=8A=A4 =
=EC=A0=9C=EA=B3=B5=ED=95=B4 =EB=93=9C=EB=A6=AC=EA=B2=A0=EC=8A=B5=EB=8B=88=
=EB=8B=A4.=C2=A0</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr"=
 class=3D"gmail_attr">2024=EB=85=84 7=EC=9B=94 12=EC=9D=BC (=EA=B8=88) =EC=
=98=A4=ED=9B=84 8:39, Muhammad Waqas &lt;<a href=3D"mailto:waqas.m@bitnine.=
net">waqas.m@bitnine.net</a>&gt;=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">ora=
2pg for object migration<div>sqllines for data migration=C2=A0</div><div><b=
r></div><div>above tools are tested=C2=A0</div></div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">2024=EB=85=84 7=EC=9B=94 12=
=EC=9D=BC (=EA=B8=88) =EC=98=A4=EC=A0=84 5:02, Sam Stearns &lt;<a href=3D"m=
ailto:sam.stearns@dat.com" target=3D"_blank">sam.stearns@dat.com</a>&gt;=EB=
=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1:<br></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div dir=3D"ltr">Howdy,<div><br></div><div>We have a pr=
oject to migrate our Oracle databases that are hosted on an Oracle Database=
 Appliance to Postgres hosted on a Linux VM.=C2=A0 Questions:</div><div><br=
></div><div><ol><li>Is there a tool out there that we can use to analyze re=
source sizing on the Appliance that will give resource sizing recommendatio=
ns for the VM?</li><li>Is there a schema conversion tool or similar out the=
re that we can use to convert Oracle =3D=3D&gt; Postgres?</li></ol><div>Tha=
nks,</div><div><br></div><div>Sam</div><div><br></div><span class=3D"gmail_=
signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature">=
<div dir=3D"ltr"><p style=3D"color:rgb(0,0,0);font-family:Gotham,&quot;Helv=
etica Neue&quot;,Helvetica,Arial,sans-serif;font-size:0.8rem;line-height:1.=
2rem"><strong style=3D"font-size:0.9rem;color:rgb(51,51,51)">Samuel Stearns=
</strong><br><span style=3D"color:rgb(102,102,102)">Lead Database Administr=
ator<br><strong>c:</strong>=C2=A0971 762 6879=C2=A0<span style=3D"color:rgb=
(147,149,152)">|</span>=C2=A0<strong>o:</strong>=C2=A0503 672 5115=C2=A0<sp=
an style=3D"color:rgb(147,149,152)">|</span>=C2=A0DAT.com</span></p><div st=
yle=3D"color:rgb(0,0,0);font-family:&quot;Times New Roman&quot;;font-size:m=
edium"><a href=3D"https://www.dat.com/?utm_medium=3Demail&amp;utm_source=3D=
DAT_email_signature_link" target=3D"_blank"><img src=3D"https://www.dat.com=
/wp-content/uploads/media/images/global/emails/signature2/dat_126.png" alt=
=3D"DAT" width=3D"126" height=3D"54"></a></div></div></div></div></div>
</blockquote></div>
</blockquote></div>

--00000000000047127e061d0ca63a--