Search Postgresql Archives

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

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

 



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





[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