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

Conference ilbbak::ibi_focus

Title:FOCUS, from INFORMATION BUILDERS
Moderator:ZAYIUS::BROUILLETTE
Created:Thu Feb 19 1987
Last Modified:Mon May 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:615
Total number of notes:1779

464.0. "Converting .FOC to .RDB ???" by WMOIS::TOMASZEWICZ () Thu Oct 03 1991 16:25

       Current situation:
       -----------------
    	Running FOCUS against both .FOC databases and .RDB databases. The
        .RDB databases are most recent created and .FOC oldest databases.
    
    
       Desired situation:
       -----------------
        To have an all .RDB shop:
                      (1) Independence from FOCUS, flexible to use
                          whatever Rdb tool we see fit. 
                      (2) Closer to all DEC solution. (cost savings)
                      (3) Make better use of Rdb servers for remote access
                          to data.
                      (x) etc.,etc.,etc.
    
        Problem statement:
        -----------------
          How to convert .FOC formatted databases to .RDB formatted databases?
    
        Inquiry:
        -------
          Can anyone suggest a way or ways to convert a FOCUS database to a
          RDB database without any affect to the data? What are the steps
          that need to happen? Is there any automated conversion routine?
    
    Thanks for any suggestive responses.......Pt
T.RTitleUserPersonal
Name
DateLines
464.1The long and tedious route ?SHIPS::CARSE_DFri Oct 04 1991 05:3417
    
    No automatic conversion that I know of (...no doubt someone will prove
    me wrong !)
    
    The logical way to approach this is to:
    
    1)	define the tables in your new Rdb/VMS database.
    2)	extract the data from the FOCUS database to fit the Rdb/VMS table
    	definitions i.e. use TABLE or MODIFY to extract all the data (in
    	the format you require) for a particular Rdb/VMS table into a
    	sequential file
    3)	you could then look at using RMU/LOAD to get the data into Rdb
    	or you will need to write a little load routine in your favourite
    	programming language.
    4)	repeat steps 2) and 3) for each Rdb/VMS table.
    
    Hope this helps   -  David