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
