HP OpenVMS Systems

Loading RMS data into a relational database?

» close window

The Question is:

 
We have multiple VAX / Alpha platforms running OpenVMS storing data in direct
access files supported in Fortran / C programming environments.  We would
like to update SQL databases existing on NT platforms.  What Middleware/
toolkits exist for exporting data from a VMS environment to an NT/SQL database?
 
 

The Answer is :

 
  The formats of RMS files on OpenVMS are entirely application-specific.
 
  Migration would entail unloading and converting the data into a format
  suitable for the target system.  Tools such as CONVERT and FDL can be
  used on OpenVMS, to get to an intermediate format -- typically text
  -- that can be loaded into the database.  Application-specific porting
  tools may also be required, as well, as the format of an RMS database
  is seldom exactly what one would want for a relational database.
 
  Tools are available to allow remote access to RMS files via ODBC, and
  OpenVMS database applications can use ODBC to access databases on remote
  systems via embedded SQL, as well.
 

  

     

     
answer written or last revised on ( 30-JUL-1998 )
     
» close window