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

[VAXman- at SendSpamHere.ORG]

In article <fd1c58a2-9040-461e-b221-a38c8587ac6d at googlegroups.com>, Robert Nelson <26212714h at gmail.com> writes:
>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.

I'd suggest you email Hein at Attinuity for details on Attunity supported RMS
infrastructure but I believe you are wrong about the support for Oracle from
them.

-- 
VAXman- A Bored Certified VMS Kernel Mode Hacker    VAXman(at)TMESIS(dot)ORG

I speak to machines with the voice of humanity.