From: | Eugene Poole <etpoole60(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? |
Date: | 2017-12-07 05:46:14 |
Message-ID: | b63318b5-9d33-011b-9ca2-9b90779d8a7a@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2017-12-07 06:22:16 | Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? |
Previous Message | Dylan Luong | 2017-12-07 05:29:00 | RE: clean out ./data/base/pgsql_tmp |