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

[Jan-Erik Soderholm]

Den 2016-02-19 kl. 10:02, skrev Robert Nelson:
> On Friday, February 19, 2016 at 1:42:12 PM UTC+5:30, Jan-Erik Soderholm
> wrote:
>
>> Should it be a 1-to-1 copy of the RMS record structure into a Oracle
>> table? Or are there any other processing involved?
>>
> One-to-One. No need for any transformation.
>
>> 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.
>
> Thanks, but this would be for a client and RDB would introduce another
> level of IT red-tape.
>

If the client has money I guess there are external solutions
with gateways against both RMS and Oracle, like Attunity. :-)

It also depend on the downtme window available for this switch.

What about simply reading the data out to a textfile an then
using the standard load tools in Oracle? Or writing an application
that just moves the data? Then you can add whatever "logging"
and other functions you like.

Jan-Erik.