PostgreSQL Software
:MigrationSave cost, achieve flexibility, and break free from vendor lock-in by migrating your data and database schema from Oracle, Microsoft SQL Server, MySQL and other sources to PostgreSQL.
Migration Portal
Migration Portal gives you detail on what will be needed to migrate your Oracle database to PostgreSQL, and then starts the migration by producing DDLs that are compatible with EDB Postgres Advanced Server.
Also supported by EDB
Migration Toolkit
A feature-rich command-line tool to migrate tables and data from your DBMS to PostgreSQL or EDB Postgres Advanced Server
EDB Migration Tool Comparison
| Feature | Migration Toolkit | Migration Portal |
|---|---|---|
| Subscription Required | Yes | No |
| Schema Assessment | No | Yes |
| Schema Migration | Yes | Yes |
| Data Migration | Online and Offline | No |
| Object Type Scope | Storage and Code | Storage and Code |
| Object Definition Validation | Yes | Yes |
| Source Database | Oracle, SQL Server (limited), Sybase (limited), MySQL (limited) | Oracle |
| Source Input | Remote connection | Uploaded file |
| Target Database | EPAS (9.6-current), PostgreSQL (limited) | EPAS (current - 1) |
| Target Output | Remote connection or direct to file | Remote connection or direct to file |
| Volume | Multiple schemas | Multiple schemas |
| DDL output | Yes, with DDL or data only | Yes |
| DDL Workarounds | Limited error handling and workarounds | Repair handlers to “fix” DDL or errors with knowledge base for manual fixes |
| Tool Interface | CLI | GUI |