[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

863.0. "ADABAS to Rdb conversion???" by NYTP11::TIM () Tue Feb 12 1991 22:44

    I have been contacted by a customer who is in need of information
    regarding a possible conversion of an ADABAS application.  The application 
    is running on a VAXcluster, and has upwards of 400 concurrent users.  The
    customer has a 9000, and is considering minimally converting the
    database to Rdb, with the potential of performing a full conversion of
    the application onto a DECtp platform.  With all of this in mind, is
    anyone aware of the existence of any conversion tools which might
    facilitate this conversion?  Has anyone any experience with such an
    ADABAS to Rdb conversion, and if so, could you give any indication of
    the effort involved?  Any information would be greatly appreciated.    
T.RTitleUserPersonal
Name
DateLines
863.1What does application use?NOT003::DENTIIan Dent @NOT, Nottingham, UKWed Feb 13 1991 12:4926
    A key thing to find out is how the application code accesses the
    Adabas database.
    
    Is it written in Natural, a 3 GL with Adasql embedded or using direct
    calls to Adabas database interface.
    
    If Natural then the Natural/Rdb product from Software AG may help
    you. This is claimed to allow same Natural V2 syntax to work against
    Adabas or Rdb (or both) databases.
    
    If Adasql then could replace SQL with embedded SQL statements. Software
    AG SQL is different to everyone else's SQL so you need a detailed
    examination of what features are used.
    
    If direct calls then you need to re-write all calls in SQL. This
    will be a big job as logic of programs may have to be changed.
    
    Conversion of database from Adabas to Rdb may be complex. Adabas
    is not relational and allows repeating fields and groups within
    a table. The design of the Rdb database is likely to be
    very different from that of Adabas and changes to programs to support
    the new design would be needed. Natural/Rdb may help in converting
    the data as a program could be written to read from Adabas and write
    to Rdb.
    
    Ian
863.2If no DECtp, then what?TRCO01::MCMULLENKen McMullenWed Feb 13 1991 20:145
    You mention that your customer is a "potential DECtp" customer. If they
    are not going to use ACMS, then what software are they going to use for
    development?
    
    Do you know why they want to convert from ADABAS to Rdb/VMS?