Resources

OpenVMS Rdb to Postgres or Oracle tool launched

Jon Power
Jon Power, CEO of Sector7, has led in OpenVMS migration for over 39 years, pioneering patented tools and methods to handle complex migrations. His hands-on approach ensures successful, on-time and on-budget project delivery.
Sector7 has enhanced VX/SQLMOD to generate Postgres ECPG from SQLMOD in addition to Oracle Pro*C. VX/SQLMOD also generates test drivers for all SQLMODs converted, making unit testing simple and low cost.

Description:

VX/SQLMOD is a powerful migration tool that converts Rdb SQLMOD procedures into embedded SQL in C using Oracle Pro*C or Postgres ECPG. This transformation allows existing VMS/OpenVMS applications to access Postgres or Oracle databases on Linux while maintaining the original business logic and structure. VX/SQLMOD supports both on-premises and cloud-based database migrations, providing cost savings and performance enhancements while ensuring compatibility with future database technologies.
‍

Why Migrate Rdb SQLMOD to Oracle or Postgres?

Eliminate Dependence on Rdb and Reduce Costs

• Postgres offers up to 80% cost savings for enterprises transitioning away from proprietary database solutions.

• By migrating Rdb to Oracle or Postgres, businesses can modernize their infrastructure while retaining full application functionality.

Seamless Integration with Existing VMS/OpenVMS Applications

• Applications using Rdb SQLMOD procedures can continue to run on VMS/OpenVMS or migrate to Linux without modifications.

• The converted SQLMOD procedures interact natively with Oracle and Postgres databases, enabling organizations to transition smoothly.

VX/SQLMOD Migration Process

Step-by-Step Conversion Workflow

1. Reads SQLMOD source code from Rdb applications.

2. Generates Pro*C or ECPG embedded SQL modules, maintaining functional equivalence.

3. Extracts and converts data type definitions from the VMS CDD libraries into equivalent C header files.

4. Modifies SQL calls to conform to ANSI SQL standards, ensuring compatibility with Oracle and Postgres.

5. Produces compiled C modules that integrate seamlessly with Fortran, COBOL, C, and C++.

6. Links the newly generated code with the original application, allowing for immediate execution.

‍