These are the tasks involved in an end-to-end migration from an Oracle database to an EDB Postgres Advanced Server cluster managed by Hybrid Manager (HM). The process uses two agents: the EDB Postgres AI agent (beacon-agent) to register your Oracle database with HM and ingest schema for assessment and conversion, and the EDB DMS agent (cdcagent) to perform the actual data migration.
Configure your auxiliary machine — Configure the auxiliary machine that acts as the bridge between your Oracle source and HM. This machine hosts both agents.
Prepare your Oracle source database — Create a dedicated migration user and configure your Oracle database to support schema ingestion and Change Data Capture (CDC).
Configure the EDB Postgres AI agent — Install and configure the EDB Postgres AI agent to connect your Oracle database to HM. This enables migration assessment and automatic schema DDL extraction for use with Migration Portal.
Prepare your destination database — Set up the HM-managed EDB Postgres Advanced Server cluster that will receive the migrated schema and data.
Migrate your schema — Use Migration Portal to convert your Oracle DDL to be compatible with EDB Postgres Advanced Server, then import the schema to the destination database before data migration begins.
Configure the EDB DMS agent — Configure the EDB DMS agent in reader mode to read changes from your Oracle source for data migration.
Migrate your data — Create and run the data migration in the HM console.