When you want to move data from one database structure into a different database with a non-matching table-and-field structure, you can build a correspondence file that maps the different locations of data between the two. A correspondence file can be used equally to import data from a non-matching structure, or to export data into a different structure.The correspondence file is simply a text file that describes which table/field data locations in the source correspond to which table/field data locations in the target database:FROM: > TO:OldTable1.Field1 > NewTable.FieldAOldTable1.Field2 > NewTable.FieldBOldTable2.Field1 > NewTable.FieldCetc.Correspondence files can be written from the beginning in a text editor, but gINT provides a utility to build a correspondence file based on the target and source structures:
Once written, the correspondence file can be used as often as needed, whenever the source and target structures match those used to create the correspondence file.