Consistency checks between database systems

A computing system that implements a consistency check tool at a second database system, the computing system comprising:

• memory;
• one or more processing units coupled to the memory;
• and
• one or more non-transitory computer readable storage media storing instructions that, when loaded into the memory, cause the one or more processing units to perform operations for:
• receiving a plurality of test conditions from a first database system, a test condition specifying at least one constraining table, at least one constraining field of the at least one constraining table, and at least one test value for the at least one constraining field, wherein the first database system does not send with the test condition values of a constrained table of the first database system that are not used in a test condition;
• executing the plurality of test conditions to produce test results indicating whether the plurality of tests succeeded or failed;
• sending at least a portion of the test results to the first database system;
• receiving an update from the first database system, the update comprising at least one update value referencing a test value associated with at least one of the plurality of test conditions;
• and
• applying the update, the applying the update comprising, for a table of the second database system, adding or modifying at least one table value with the update value.

One or more non-transitory computer-readable storage media storing computer-executable instructions for causing a computing system, comprising a first database system and a second database system, to perform processing to method of checking consistency of an update to be sent from the first database system to the second database system and applied at the second database system, the method comprising:

• at the first database system:
• determining at least a first table to be updated at the first database system, the at least a first table being a constrained table;
• determining at least a first constraining field of a constraining table that constrains at least a first field, being a constrained field, of the at least a first table;
• determining values of the constrained field in records of the first table;
• generating a plurality of test conditions, wherein a test condition is created at least for unique values of the determined values;
• and
• sending at least a portion the plurality of test conditions to the second database system to be executed at the second database system;
• at the second database system:
• receiving the at least a portion of the plurality of test conditions from the first database system, a test condition specifying at least one constraining table, at least one constraining field of the at least one constraining table, and at least one value for the at least one constraining field, wherein the first database system does not send with the test condition values of a constrained table of the first database system that are not used in a test condition;
• executing the plurality of test conditions to produce test results indicating whether the plurality of tests succeeded or failed;
• sending at least a portion of the test results to the first database system;
• at the first database system:
• receiving the at least a portion of the test results from the second database system;
• making one or more changes to an update to be sent to the second database system based at least in part on the test results;
• and
• sending the update to the second database system, wherein the update includes at least one update value referencing a test value associated with at least one of the plurality of test conditions;
• and
• at the second database system:
• receiving the update from the first database system;
• and
• applying the update, the applying the update comprising, for a table of the second database system, adding or modifying at least one table value with the update value.