Migrating from RMS to Oracle

[Peter Bateman]

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