How cybertec-postgresql/ora_migrator works
ora_migrator is a PostgreSQL extension that adds Oracle-specific migration support to db_migrator, using oracle_fdw to access Oracle. The principal workflow is to prepare migration stages, create Oracle metadata foreign tables, check and clean problematic source data, then migrate tables; replication supports near-zero-downtime migration. The README documents these capabilities, but no source excerpts were provided, so implementation nodes share the extension SQL file and relationships are limited to those explicitly described in the README.
Main entry points: ora_migrator--1.1.0.sql Metadata views
Components 19
Migration support
- Migration callbacks
ora_migrator--1.1.0.sql - Migration stages
ora_migrator--1.1.0.sql
Oracle metadata
- Metadata views
ora_migrator--1.1.0.sql - Package source
ora_migrator--1.1.0.sql - Segment information
ora_migrator--1.1.0.sql - Cost estimates
ora_migrator--1.1.0.sql - Table comments
ora_migrator--1.1.0.sql - Column comments
ora_migrator--1.1.0.sql
Data validation
- Table data test
ora_migrator--1.1.0.sql - Migration data test
ora_migrator--1.1.0.sql - Test error records
ora_migrator--1.1.0.sql - Error summaries
ora_migrator--1.1.0.sql
Replication
- Replication setup
ora_migrator--1.1.0.sql - Replication objects
ora_migrator--1.1.0.sql
Other components
- Migration operator
- db_migrator
- oracle_fdw
- Oracle database
- PostgreSQL database
Connections 24
- Migration operator → db_migrator: runs migration
- db_migrator → Migration callbacks: requests callbacks
- db_migrator → Migration stages: prepares and migrates
- Migration operator → Metadata views: creates views
- Metadata views → oracle_fdw: creates foreign tables
- oracle_fdw → Oracle database: accesses
- Metadata views → Package source: exposes
- Metadata views → Segment information: exposes
- Metadata views → Cost estimates: exposes
- Metadata views → Table comments: exposes
- Metadata views → Column comments: exposes
- Migration operator → Table data test: tests after preparation
- Table data test → oracle_fdw: tests Oracle rows
- Migration operator → Migration data test: runs data checks
- Migration data test → Table data test: checks each table
- Migration data test → Test error records: records results
- Migration data test → Error summaries: records summary
- Test error records → oracle_fdw: stored in FDW stage
- Error summaries → oracle_fdw: stored in FDW stage
- Migration operator → Replication setup: starts replication
- Replication setup → Oracle database: creates Oracle objects
- Replication setup → PostgreSQL database: creates PostgreSQL objects
- Replication setup → Replication objects: creates
- Replication objects → Migration stages: supports table migration