[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

133.0. "Oracle -> Rdb data transfers" by TROU02::SPACKMAN () Tue May 17 1988 21:51

    Has anyone had experience in moving data from an Oracle database
    into an Rdb database? Are there any tools within Oracle to unload
    data into ascii (RMS) files or would it require a custom built program?
    Does Rdb have any tools to do the reverse or would DATATRIEVE be the
    best approach?
    
    This is being asked due to a potential sales situation where the
    customer is interested in an application (3rd party) that has been
    written using Oracle, but who may be open to the idea of using Rdb
    as the corporate database for all other appliations. There would
    likely be a need to feed data from the Oracle environment to the
    Rdb environment.
    
    Thanks
    Janet
T.RTitleUserPersonal
Name		DateLines
133.1One AnswerQUILL::BOOTHA Career in MISunderstandingWed May 18 1988 21:219
    Oracle does have an import/export utility that can be used to bring
    in RMS files or dump Oracle data to an RMS file.
    
    There needs to be a "loader" utility for Rdb/VMS, but there isn't.
    Easiest way is using SMARTSTAR's SMARTMOVE. That will be relatively
    fast as well. Datatrieve will work, as will embedded SQL statements
    in a 3GL program.
    
    ---- Michael Booth
133.2Another answer and some commentary.....IRT::MCGOVERNThu May 19 1988 23:1143
    
    re .1
    The Oracle Export utility will output to an RMS file (of course)
    but that file contains more than just data, it has CREATE TABLE
    information and space allocation information and is in a non-standard
    Oracle proprietary format. 
    
    The Oracle Import utility can only read files created with the
    Export utility.
    
    With the VMS version of thier product, Oracle provides a utility,
    called the Oracle Data Loader (ODL), which can load data from an
    RMS sequential pure data file into an Oracle database, but does
    not currently go the other way.
    
    All of my comments are based on Oracle 5.1.
    
    I don't know anything about the SMARTSTAR product mentioned in .1,
    but the only way to move data from an Oracle database to an Rdb/VMS
    database using Oracle and Digital provided tools (that I am aware
    of) involves writing code. Specifically:
    
    	- Write a SQL*plus program to query the Oracle database and
    	  output the extracted columns to a report file without defining
    	  any title, headings, page numbers etc.
    
    	- Write a program in some 3GL using the Oracle report file as
    	  input and embedded VAX SQL or RDO commands to get the data
    	  into an Rdb/VMS database.
    
    
    Also, Oracle has a soon to be announced product called SQL*Loader.
    Exactly what the functionality of this product will be I don't know,
    but I expect it will be an expansion of ODL's capabilities only.
    
    
    
    
    
    						Mike McGovern