Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

Thanks, That's why I'm starting now and I have until 2020.

What happens if I use the Oracle DDL on PostgreSQL?   It's not much with 
plsql but it has a lot of foreign keys and sequence fields.

TIA

Gene


On 12/7/2017 12:02 AM, John R Pierce wrote:
> On 12/5/2017 10:59 AM, Eugene Poole wrote:
>>
>> 3. Would I use ora2pg do do the move? Is ora2pg still maintained?
>>
>> 4. Is there a better conversion package?
>>
>
> there are a variety of "ETL" tools out there that can extract data 
> from one database and load it into another.   I was going to suggest 
> pgloader, but that doesn't support oracle, only mysql and ms sql server.
>
> a full scale conversion of a complex application suite, however, can 
> be a several year project.     Our old Oracle application was very 
> heavy on plsql.  We chose to reimplement the vast majority of the 
> business logic in appserver modules outside the database and only used 
> plpgsql for things where performance mattered significantly.
>
> the more heavily your apps use Oracle specific features, the more work 
> the conversion will be.
>

-- 
Eugene Poole
Woodstock, Georgia