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
