Method and apparatus for verifying converted database commands

A system for verifying a conversion of at least one database command, comprising:

• a database command converter having an input for receiving the at least one database command in a first format, the database converter for converting from the first format to a second format the at least one command corresponding to an intended result, and for providing at an output the at least one database command in the second format;
• a user interface manager having a first input coupled to the database command converter output for receiving the at least one database command in the second format, the user interface manager for providing at an output coupled to a first database program the at least one command in the second format to the first database program that will not execute, in a manner that produces the intended result, the command in the first format, the user interface manager additionally for providing to a second database program coupled to the user interface manager output at least one selected from:
• the at least one command in the first format received at a second input;
• at least one command in a third format converted from the first format by the database command converter and provided at the database command converter output coupled to a third input;
• and
• the at least one command in the second format received from the database command converter output coupled to the third input;
• a result receiver having an input coupled to the first database program and the second database program, the result receiver for receiving a first result from the first database program and a second result from the second database program and providing the first result and the second result at an output;
• a result comparer having an input coupled to the result receiver output, the result receiver for comparing a content and row order of the first result and the second result and providing an indication of said comparison at an output;
• and
• a result action identifier having an input coupled to the result comparer output for receiving the indication, the result action identifier for determining a validity of the command in the second format responsive to the indication received at the result action identifier input.

A computer program product comprising a computer useable medium having computer readable program code embodied therein for verifying a conversion of at least one database command, the computer program product comprising computer readable program code devices configured to cause a computer system to:

• convert from a first format to a second format the at least one command corresponding to an intended result;
• provide the at least one command in the second format to a first database program that will not execute, in a manner that produces the intended result, the command in the first format;
• receive a first result from the first database program;
• provide to a second database program at least one selected from:
• the at least one command in the first format;
• at least one command in a third format converted from the first format;
• and
• the at least one command in the second format;
• receive a second result from the second database program;
• compare a content and row order of the first result and the second result;
• and
• determine a validity of the command in the second format responsive to the computer readable program code devices configured to cause the computer system to compare.