[Info-vax] Migrating data from RMS : Available tools

Robert Nelson 26212714h at gmail.com
Fri Feb 19 02:33:42 EST 2016


Hello List
We would like to migrate data off RMS-based index files. The 2 files have about 30 million records combined.

Our goal is to move the data from RMS to Oracle (not RDB). I would like to know if there are tools that can assist with this : with error logging, repeatability and customisation. 

My initial investigation's results are :
1. ConnX - connect to RMS, configure CDDs and extract RMS data to CSV. Use SQL loader to load data to Oracle. This is a two step process and needs manual steps to extract data from RMS to CSV, verify errors.

2. I remember Attinuity as a leading vendor for providing solutions to access VMS systems. However, their Replicate product seems to support only DBMS sources. No mention of RMS.

3. Oracle Gateways : No love for RMS ?

4. Open Transl8 - marketed by advancedcomputersoftware & Transoft.

What do you all think?
Thank you.



More information about the Info-vax mailing list