Raj48
3 years agoNew Contributor
Compare two SQL query results data
Hi,
Is there any way to compare two SQL queries data in TestComplete through Database checkpoint?
For ex:
SQL query 1 - DBTable1
SQL query 2 - DBTable 2
and then compare --> DBTable1 vs DBTable2
As i understand, DBCheckpoint will fetch and compare the results against base data. Not sure how to keep base data from SQL query 2 and compare it with SQL Query 1.
Please suggest.
Tried File Checkpoint already (by exporting the data from both the queries into different sheets and compare). Just want to know, if DBCheckpoint can help here.
Creating the table entry for comparison would be a manual process and if your tables change frequently, that's not the best way to go. If the file compare is doing what you need, then I would stick with that.