Moving from Rdb to Oracle and PostgreSQL on OpenVMS

Abstract
Presented by Denys Beauchemin at the VMS Bootcamp on May 15, 2025.
What the talk covers
- Why move away from Rdb when support is hard to find and the access methods are not industry standard.
- Roadmap away from Rdb: replicate data storage in the target RDBMS, then migrate Rdb access methods to fit PostgreSQL or Oracle.
- Application considerations: SQLMODs to Pro*C or SQLPGPCs, embedded SQL to SQLMODs, date formats, tinyints, and overloaded tables.
- Targets named on the slides: PostgreSQL (suggest V16) and Oracle 19 as the last Oracle release from OpenVMS with an existing client.
- Rdb access in application code: SQLMOD workflows with VX/SQLMOD and embedded SQL extraction with VX/EMB2MOD.
- FLOW diagram for COBOL: from original RDML or embedded SQL sources through conversion, precompile, compile, and link.
- Agenda flow from data storage move through application considerations before the database underneath changes.
Recording
Slides
Trusted by top companies around the globe



