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 |
[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)

