PostgreSQL

From Oracle FAQ

PostgreSQL is an open source relational DBMS system. PostgreSQL runs on several platforms including Linux, Windows, HP-UX, Solaris and AIX.

Contents 1 Compared to Oracle 2 Migration to Oracle 3 Migration from Oracle 4 Also see 5 External links

[edit] Compared to Oracle

Of all open source databases available, PostgreSQL is the closest to Oracle.

[edit] Migration to Oracle

Oracle doesn't offer any tools that can convert PostgreSQL databases to Oracle. The following third party solutions are, however, available:

• SQLWays - comprehensive, but expensive migration solution
• SwissSQL - don't have the full functionality required

[edit] Migration from Oracle

Tools like Ora2pg and DBI-Link can be used to convert or interact with Oracle tables:

• Ora2pg - Perl module to export an Oracle schema to PostgreSQL
• DBI-Link - uses Perl's DBI module to link to remote data sources (like Oracle) and treat them as PostgreSQL tables

[edit] Also see

• MySQL - open-source database
• EnterpriseDB - proprietary extensions on top of PostgreSQL (provides Oracle compatibility)

[edit] External links

• PostgreSQL Home Page