Patent ID: 7337176

Claim:
A data loading tool stored on a computer readable medium for loading a target database, comprising: an initialization component that obtains a tables list that identifies tables of a source database, wherein an order in which the tables are listed in the tables list identifies a relational association of the tables in the source database; the initialization component further receives requested test data, identifies a first table in the tables list, searches the first table by a primary key of the first table to locate, identifies at least one secondary key of the first table, and identifies a first data that is related to the requested test data by associating the at least one secondary key of the first table with the location of the requested test data in the primary key of the first table, the initialization component further identifies a second table in the tables list with a primary key of the second table that is the at least one secondary key of the first table, identifies at least one secondary key of the second table, and identifies second data that is related to the requested data by associating the at least one secondary key of the second table with a location of the first data in the primary key of the second table, the initialization component further generates a load file that maintains a record of tables, keys, and data identified by the initialization component in an order that maintains a relational integrity of the source database; a control generator that generates at least one control file related to the source database; an extractor component that extracts data from the source database based on the load file; and a loader component that loads the data extracted by the extractor component into the target database utilizing the at least one control file, wherein the data loaded into the target database maintains the relational integrity of the source database.