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

Compared to Oracle

From all the open source databases around, PostgreSQL is the closes to Oracle.

Migration to Oracle

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

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

Migration from Oracle

Tools like Ora2pg and DBI-Link can be used 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

Also see

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

External links

• PostgreSQL Home Page