Multi-table data validation tool

At least one non-transitory machine-readable storage medium comprising instructions that, when executed by a processor, cause the processor to:

• retrieve a first table from a source database, wherein the source database is a first type of database;
• retrieving a second table from a target database, wherein the target database is generated by migrating the source database;
• perform a column level data analysis by:
• selecting a column of the first table;
• selecting an analogous column of the second table;
• comparing first data in the first column with second data in the analogous column;
• and
• generating a first file to store differences between the first data and the second data;
• and
• wherein one or more portions of the source database are tokenized such that the target database includes at least the tokenized portions, wherein the tokenized portions comprises substitutes of confidential information that has been stripped from the source database prior to migration and the tokenized portions being masked in first memory locations, and the target database being a second type of database different from the first type of database, and the tokenized portions being masked in second memory locations.

An apparatus comprising a processor and memory coupled to the processor, the memory comprising instructions that, when executed by the processor, cause the processor to:

• tokenize one or more portions of a source database;
• extract a first table from the source database into first memory locations, wherein the source database is a first type of database;
• generate, by migrating the source database, a target database including at least the tokenized portions, wherein the tokenized portions comprises substitutes of confidential information that has been stripped from the source database prior to migration and the tokenized portions being masked in the first memory locations, and the target database being a second type of database different from the first type of database;
• extract a second table from a target database into second memory locations, the tokenized portions being masked in the second memory locations;
• perform a first comparison between the first memory locations and the second memory locations to determine a mismatch in the number of rows between the first table and the second table, wherein the first comparison is stored in a row count file;
• perform a second comparison between data stored in the first memory locations and the second memory locations to determine a mismatch in the data between the first table and the second table, wherein the second comparison is stored in a column delta file;
• analyze the row count and column delta files to update a software program used to migrate the source database to the second database engine.