[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