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

[Jan-Erik Soderholm]

Den 2016-02-19 kl. 08:33, skrev Robert Nelson:
> 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.
>

Should it be a 1-to-1 copy of the RMS record structure into
a Oracle table? Or are there any other processing involved?

I have read from  RMS and written to Rdb in one go using Python.
The Python kit for VMS has both RMS and Rdb support.

Maybe here are some Oracle client kit for Python also.

We also have the "Rdb transparent gateway for Oracle" that
probably can be used. It's free but unsupported.

Jan-Erik.