Search Postgresql Archives

Re: Oracle to postgres migration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux