System and method for mapping database changes

A system for identifying updates to software that cause changes to databases accessible by the software, the system comprising:

• a memory configured to store one or more processor-executable routines;
• and
• a processor configured to communicate with the memory and to execute the routines stored therein, wherein the routines, when executed, cause the system to:
• modify a database storing data associated with a software application, wherein modifying the database comprises using first instructions associated with a first software update to the software application to generate a first modified database;
• modify the database using second instructions associated with a second software update to the software application to generate a second modified database;
• generate a many-to-many table, wherein the many-to-many table maps one or more records in the database that were changed based on the first and second instructions, wherein the many-to-many table comprises information associated with respective application files from which the first software update and the second software update originated;
• determine a difference between the first modified database and the second modified database;
• and
• identify, based on the difference, one or more instructions of the first instructions or the second instructions that caused the difference.

A method, comprising:

• generating a second database from a first database based on instructions associated with one or more software updates to a software application, wherein the one or more software updates modify the first database using the instructions associated with the one or more software updates;
• generating a table, wherein the table maps one or more records in the first database that were changed based on the instructions, wherein the table comprises information associated with respective application files from which the one or more software updates update originated;
• determining a plurality of differences between the first database and the second database;
• and
• determining which respective instruction of the instructions caused the plurality of differences between the first database and the second database.