pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
 Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)
4+ messages / 4 participants
[nested] [flat]

*  Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-23 09:37  Chetan Kosanam <chetan.kosanam@tcs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Chetan Kosanam @ 2022-12-23 09:37 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>; Veerraju Yeluduti <veerraju.y@tcs.com>

TCS Confidential

Hi Support@ PostgreSQL Team,

Greetings !!

  We are operating within one of the AWS business units of TCS. Our team is working on the Database migration from Oracle(on Amazon EC2) to PostgreSQL. The reason for this e-mailer is to seek your earnest required support from you on the Alternative functionalities from Oracle --> PostgreSQL while migrating the Oracle database to PostgreSQL.


S. No.
Oracle functionalities
PostgreSQL Equivalent
1
dbms_lob . --> ( createtemporary , OPEN , lob_readwrite , getlength , writeappend , SUBSTR )
Need the respective equivalent for the Oracle functionalities present in the adjoining column
2
dbms_sql
3
dbms_utility
4
utl_http.begin_request
5
DBMS_LDAP
6
UTL_RAW .  --> ( cast_to_varchar2 , LENGTH , cast_to_raw )

In case we don’t have any exact equivalent, please advise on the methodology to get the needful done.
Thanks & Regards,
Chetan Kosanam
TCS,  HYDERABAD
Contact : 9502753544
Mailto : chetan.kosanam@tcs.com



TCS Confidential
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-28 17:45  Adrian Klaver <adrian.klaver@aklaver.com>
  parent: Chetan Kosanam <chetan.kosanam@tcs.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Adrian Klaver @ 2022-12-28 17:45 UTC (permalink / raw)
  To: Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>; Veerraju Yeluduti <veerraju.y@tcs.com>

On 12/23/22 01:37, Chetan Kosanam wrote:
> TCS Confidential
> 
> 
> Hi *Support*@ *PostgreSQL* Team,
> 
> *Greetings* *!!*
> 
> **
> 
> **We are operating within one of the /AWS business/ units of *TCS*. Our 
> team is working on the *Database migration from Oracle(on Amazon EC2) to 
> PostgreSQL*. The reason for this e-mailer is to seek your earnest 
> required support from you on the *Alternative functionalities from 
> Oracle **à PostgreSQL* while migrating the Oracle database to PostgreSQL.

See here:

https://www.postgresql.org/support/professional_support/


-- 
Adrian Klaver
adrian.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-29 02:15  rob stone <floriparob@tpg.com.au>
  parent: Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 1 reply; 4+ messages in thread

From: rob stone @ 2022-12-29 02:15 UTC (permalink / raw)
  To: Adrian Klaver <adrian.klaver@aklaver.com>; Chetan Kosanam <chetan.kosanam@tcs.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: Harinarayana Kadiyala <harinarayana.kadiyala@tcs.com>; Md Rakibuddin <md.rakibuddin@tcs.com>; SAI CHANDANA CHAMALA <sc.chamala@tcs.com>; Sandu Sai Prasad <saiprasad.sandu@tcs.com>; UPPALA NIKHITA <venkata.uppala@tcs.com>; Sai Pratyusha Gantimahapatruni <sai.gantimahapatruni@tcs.com>; Mohammed Imran <imran.mohammed@tcs.com>; Kotha Parvathi <kotha.parvathi@tcs.com>; Uma Puttappa <uma.puttappa@tcs.com>; Veerraju Yeluduti <veerraju.y@tcs.com>



On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote:
> On 12/23/22 01:37, Chetan Kosanam wrote:
> > TCS Confidential
> > 
> > 
> 
> See here:
> 
> https://www.postgresql.org/support/professional_support/
> 
> 

Also there is ora2pg. See https://ora2pg.darold.net/







^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration)
@ 2022-12-29 02:17  Ron <ronljohnsonjr@gmail.com>
  parent: rob stone <floriparob@tpg.com.au>
  0 siblings, 0 replies; 4+ messages in thread

From: Ron @ 2022-12-29 02:17 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 12/28/22 20:15, rob stone wrote:
>
> On Wed, 2022-12-28 at 09:45 -0800, Adrian Klaver wrote:
>> On 12/23/22 01:37, Chetan Kosanam wrote:
>>> TCS Confidential
>>>
>>>
>> See here:
>>
>> https://www.postgresql.org/support/professional_support/
>>
>>
> Also there is ora2pg. See https://ora2pg.darold.net/

That does a great job at data conversion.  Not sure about functionality 
conversion.

-- 
Born in Arizona, moved to Babylonia.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2022-12-29 02:17 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-23 09:37  Regd. the Query w.r.t Alternative functionalities from Oracle  PostgreSQL (Oracle to PostgreSQL database migration) Chetan Kosanam <chetan.kosanam@tcs.com>
2022-12-28 17:45 ` Adrian Klaver <adrian.klaver@aklaver.com>
2022-12-29 02:15   ` rob stone <floriparob@tpg.com.au>
2022-12-29 02:17     ` Ron <ronljohnsonjr@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox