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 |
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.R | Title | User | Personal Name | Date | Lines |
---|---|---|---|---|---|
464.1 | The long and tedious route ? | SHIPS::CARSE_D | Fri Oct 04 1991 05:34 | 17 | |
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 |