Migrating from RMS to Oracle

[Edis, Robert]

I think the easiest way is to use the conversion features of Axiant.  These
were developed specifically with ISAM to RDBMS conversions in mind due to
the complexity of the task.  Even if you only use this feature of Axiant it
is still a great cost effective tool for a low price.

Blue

-----Original Message-----
From: Peter Bateman [mailto:shediac92@hotmail.com]
Sent: Thursday, May 22, 2003 9:58 AM
To: powerh-l@lists.swau.edu
Subject: Re: Migrating from RMS to Oracle


Hi Sagar:

1)   I think the easiest way to migrate this application is to make each 
coded record structure a table in Oracle. I recall seeing a datatype 
conversion list in the PowerHouse documentation.

2)One could put all the data that relates to one RMS physical file into one 
table and then create several
views of the table based on the record coding. The Oracle CAST function 
might be useful. Good luck if that is way you choose to go.

Regards,
Peter Bateman



>From: "Goparaju, Vidyasagar" <VGoparaju@tradepointsystems.com>
>To: "Powerh-L (E-mail)" <powerh-l@lists.swau.edu>
>Subject: Migrating from RMS to Oracle
>Date: Thu, 22 May 2003 09:22:13 -0400
>
>Hi All,
>
>We are planning to migrating from VMS/RMS/POWERHOUSE to
>Solaris/Oracle-9i/POWERHOUSE.
>
>We have number of Files with coded record structures and Multi-Record files
>(different logicals records in the Dictionary that point to same physical
>file).
>
>Is there a way in Oracle-9i to maintain similar structures and relations?
>
>Any help/information on this is very much appreciated.
>
>Thanks
>Sagar
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.  
http://join.msn.com/?page=features/junkmail

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.