Supported databases and operating systems v1.3
The EDB Data Migration Service (EDB DMS) is available only as part of Hybrid Manager (HM).
Supported source databases
The following database versions are supported.
| Database version | Supported source |
|---|---|
| PostgreSQL 12 - 17 | Y |
| EDB Postgres Advanced Server 12 - 17 | Y |
| EDB Postgres Extended Server 12 - 17 | Y |
| Oracle 19c | Y |
| Oracle 21c (*) | Y |
| Oracle 23ai (*) | Y |
| AWS RDS PostgreSQL 13-17 | Y |
| AWS RDS Aurora (PostgreSQL compatible) 13-17 | Y |
The supported Postgres source databases include only externally managed (self-managed) databases.
Note
(*) The DMS agent supports migrating Oracle 21c and 23ai databases. However, Migration Portal doesn't. This means that to migrate 21c and 23ai databases, you must manually perform the schema migration.
Oracle
The EDB DMS stack requires the Oracle database to have archive log mode enabled and supplemental logging data enabled at the table and database level. For details, see Preparing Oracle source databases.
Container databases (CDB/PDB) and non-CDB sources are supported.
Postgres
When migrating from Postgres toward Postgres, cross-version and cross-distribution migrations are supported. You can migrate data from one version of PostgreSQL to another, such as from PostgreSQL 16 to PostgreSQL 17 or from PostgreSQL 17 to EDB Postgres Advanced Server 17. The exception is that you can't migrate from EDB Postgres Advanced Server as a source to a different distribution, for example, to PostgreSQL or EDB Postgres Extended Server.
Source Postgres instances can be self-managed instances on bare metal machines, on virtual machines, or hosted by a cloud service provider like AWS (RDS or Aurora databases).
Postgres sources require a database role or user that can manage replications. For details, see Preparing Postgres source databases.
Supported destination databases
DMS supports migrating to both HM-managed databases (on clusters created with HM) and self-managed databases running Postgres.
| Database version | Supported destination |
|---|---|
| PostgreSQL 11 - 17 (*) | Y |
| EDB Postgres Advanced Server 11 - 17 (*) | Y |
| EDB Postgres Extended Server 11 - 17 (*) | Y |
Note
(*) For HM-managed database clusters, support is only for versions 16 and 17.
DMS supports migrating to all databases listed in the table. However, Migration Portal supports schema migrations only for EDB Postgres Advanced Server versions 16 and 17. For version 15 and earlier, you must perform schema migration manually.
Oracle
EDB DMS doesn't yet support migrations to Oracle destinations.
Postgres
When migrating from Postgres toward Postgres, cross-version and cross-distribution migrations are supported, for example from PostgreSQL 16 to 17 or from PostgreSQL 17 to EDB Postgres Advanced Server 17.
Postgres destinations require a database role or user that can manage replications. For details, see Preparing Postgres destination databases.
Supported operating systems
The DMS agent runs on Linux. For details, see Installing EDB DMS agent.