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.FieldA
OldTable1.Field2 > NewTable.FieldB
OldTable2.Field1 > NewTable.FieldC
etc.
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.