Oracle to PostgreSQL Cutover Report
The cutover report is an important operational and validation document prepared to evaluate the overall readiness of an Oracle-to-PostgreSQL migration before the final cutover activity is performed.
It provides a comprehensive summary of the current migration status, data replication progress, synchronization health, and validation results. The report enables technical teams and stakeholders to review the migration state in a structured manner and confirm whether the environment is ready to switch from the source Oracle database to the target PostgreSQL database.
The report is generated in HTML format, allowing users to download, open, and review it through a web browser or any supported reporting interface. It serves as a single reference point for validating that the required database objects and data have been migrated successfully and that the replication process is functioning as expected.
Purpose of the Cutover Report
The cutover report provides a consolidated view of the Oracle-to-PostgreSQL migration status by capturing table-level migration information,replication progress, andsynchronization details between the source and target databases.
It enables users to determine how many tables have been successfully migrated, understand the migration state of each table, and monitor whether data replication is progressing without interruption.
Report Coverage
The cutover report evaluates the readiness of an Oracle-to-PostgreSQL migration before the final cutover process.
The report includes:
- Migration status of database tables.
- Replication progress and synchronization.
- Table-wise lag and offset information.
- Current replication health.
- Index replication status.
- Row count comparison.
The report is generated in HTML format and can be reviewed through a web browser.
Validation Checks
The report validates several critical indicators that help determine whether the target PostgreSQL database is ready for cutover.
- Table-wise replication lag and synchronization status.
- Total offsets, current offsets, and pending offsets.
- Index replication status for migrated tables.
- Row count comparison between Oracle and PostgreSQL.
- Detection of missing or unsynchronized records.
By reviewing these metrics, users can identify tables that require additional synchronization before the final cutover decision.
Final Cutover Status
Based on the evaluated parameters, the report automatically derives the final status as either PASS or FAIL.
- PASS: All migration and synchronization checks have completed successfully.
- FAIL: One or more validation checks require review.
This automated assessment reduces manual effort, improves transparency, and supports controlled decision-making.
Generate Report
Overall, the cutover report provides a clear and data-driven view of migration readiness. It helps teams validate migration outcomes, identify pending activities, reduce the risk of data inconsistency, and proceed with the final cutover only when all required conditions are satisfied.
<path_to_serverconfig> -cutover_report -pub <path_to_publication.config> -sub <path_to_subscription.config>