Talks

Moving from Rdb to Oracle and PostgreSQL on OpenVMS

Title slide: Moving from Rdb to Oracle and PostgreSQL on OpenVMS
OpenVMS Bootcamp Malmo 2025 · 15 May 2025 · Archived presentation
Denys Beauchemin
Grand Senior Migration Engineer, Sector7 USA LLC

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

Session page on the VSI Boot Camp site

Trusted by top companies around the globe
Harrah's logoAT&T logoNASDAQ logoJ.P. Morgan logoEY logoKronenbourg logoReader's Digest logoFord logo
MCI logoNew York City Fire Department emblemBNP Paribas logoNetflix logoAMD logoHP logoDuPont logoAlltel logo
IKEA logoBritish Airways logoChicago Stock Exchange logoAtlantic Lottery Corporation logoAK Steel logoVisa logoHertz logoWendy's logo
cloud image Sector7 openvms migrations

Reconnecting OpenVMS with our proprietary toolsets