Features
PostgreSQL Migrator is under active development.
At Dalibo, we love providing high quality softwares that help DBA on a daily basis. We are fully committed to delivering universal database conversion software and making PostgreSQL more affordable for any user.
PostgreSQL Migrator is still young. Track PostgreSQL Migrator progression in changelog.
Legend¶
Features may be global (available for all supported source systems) or system-specific. The following tables and matrices provide information about the progress of each identified feature.
| Symbol | Meaning |
|---|---|
🟢 FI |
Fully implemented |
🟠 PI |
Partially implemented |
🔴 NI |
Not implemented yet |
⚪ NP |
Not planned yet |
| - | Not applicable |
Migration¶
Here are implemented and planified features.
| Feature | Status |
|---|---|
| Audit expressions and procedures with transqlate | 🟢 FI |
| Multi-thread dump | 🟢 FI |
| Dump data to SQL files | 🟢 FI |
Streamed bulk COPY to PostgresSQL |
🟢 FI |
| Chunk large columns from source | 🟢 FI |
| Complete Web UI to explore original and converted catalog | 🟢 FI |
| Consistent dump using snapshot mecanisms | 🔴 NI |
| User defined or geometric datatypes support | 🟠 PI |
| Post-dump data validation | 🔴 NI |
| Data-type discovery mode to find the best fit | 🔴 NI |
| Table data alignment | 🔴 NI |
| Loading text or binary into PostgreSQL large object storage | 🔴 NI |
| Zero-downtime migration with Change-Data-Capture | 🔴 NI |
Versions¶
Here are the implementattion status for the different systems and versions.
| System | Support |
|---|---|
| Oracle 11g to 26ai | 🟢 FI |
| Oracle 10g | ⚪ NP |
| Oracle 9i and below | - WONT |
| System | Support |
|---|---|
| MySQL 8.4 | 🟢 FI |
| MariaDB 10.5 to 12 | 🟢 FI |
| System | Support |
|---|---|
| Microsoft SQL Server | ⚪ NP |
| Sybase™ SQL Anywhere | ⚪ NP |
| IBM Db2 | ⚪ NP |
Reach us if you have project with such system.
| System | Support |
|---|---|
| PostgreSQL 13 to 18 | 🟢 FI |
PostgreSQL is supported as a target system. PostgreSQL is the only target system supported. Other system are only supported as source of migration.
Compatibility¶
System-specific features will be implemented one system at a time. Introducing a new system may be challenging and will be planned, based on customers priorities and external contributions.
A feature should fulfill inspection, conversion and migration steps to be considered fully implemented.
For example, PostgreSQL Migrator fully implements tables conversion for limited systems, as it inspects the source catalog, converts columns data types, and copies data to target tables.
| Features | Status |
|---|---|
| Roles | 🟠 PI |
| Ownership | 🟢 FI |
| Privileges | 🔴 NI |
| Schemas | 🟢 FI |
| Sequences | 🟢 FI |
| Tables | 🟢 FI |
| Partitions | 🟠 PI |
| Constraints | 🟢 FI |
| Indexes | 🟢 FI |
| Triggers | 🟠 PI |
| Views | 🟠 PI |
| Materialized Views | 🟠 PI |
| Types | 🟠 PI |
| Routines | 🟠 PI |
| Packages | 🟠 PI |
| Synonyms | 🟠 PI |
| Database Links | 🟠 PI |
| Jobs | 🟠 PI |
| Features | Status |
|---|---|
| Roles | 🔴 NI |
| Ownership | 🟢 FI |
| Privileges | 🔴 NI |
| Schemas | 🟢 FI |
| Tables | 🟢 FI |
| Partitions | 🟠 PI |
| Constraints | 🟢 FI |
| Indexes | 🟢 FI |
| Views | 🟠 PI |
| Routines | 🟠 PI |
| Triggers | 🟠 PI |
| Autoincrement | 🟢 FI |
| Federated Tables | 🟠 PI |
| Events | 🟠 PI |
Contribute¶
Thank you for considering PostgreSQL Migrator as your migration companion. External contributions or feedback are precious. Please read our contributing guide or open an issue if you would like to improve PostgreSQL Migrator.