METHOD AND APPARATUS FOR CONVERSION OF DATABASE DATA INTO A DIFFERENT FORMAT ON A FIELD BY BASIS USING A TABLE OF CONVERSION PROCEDURES

A data conversion apparatus and method for translating information stored in a first relational database to that stored in a second relational database, and for translating information in a relational database used by a first selected version of a computer program into information stored in a second relational database for use by a second selected version of a computer program. The apparatus and method thus allow the sharing of data by computer systems running different versions of a given software package. The data conversion apparatus includes a first file storage element for storing a first relational database having a plurality of digital records representing information used by a first selected version of a computer program, and a second file storage element capable of storing a second relational database representing at least a portion of the information from the first database for use by a second selected version of the computer program. The apparatus further includes a file management element that converts information from the first database for storage in the second. That conversion is performed as a function of the identities of the first and second selected versions of the computer program. The file management element includes table entry elements that identify, in table-like form, the procedures for translating individual records or fields of information stored in the first relational database into a form compatible with the second software subroutines, each of which executes steps necessary for converting data between computer program version. Each file management table entry stores the names of the respective formats.