Compare two SQL query results

Hi,

in my application we rely heavily on database operations and its contents, so data is key asset. I'd like to use testcomplete to compare two tables from db, and I wonder if there are some features, which can help me achieve my task. What I want:

 

- dynamically query the base and compare two result sets (one from production db, one from db under tests)

- optionally I can save query results into tables and compare two tables

 

What I've tried so far:

 

-DB checkpoint - it would be perfect, but for what I understand, DB checkpoint connects to db and checks whether data saved on testcomplete side is the same as data from SQL query result. I don't know how to convince Testcomplete to save data from one query and compare it with data from another query. 

 

- saving SQL query results to separate files and comparing the files - works kinda good, but I don't have any ideas how to remove column ids from xmls (I don't even have them in my query, yet they are still there: I use ADO.SaveToFile method) apart from creating my own file, where I'd pick only things I need. I fear that would be inefficient though, and if I'm forced to write my own code, I may as well write my own comparison:

 

- comparing two result sets in my own code - it's simple, I can do whatever I want with it, but it isn't very efficient (e.g. it takes 3 mins to check 6k rows). Besides if there is any other option to do it using TC features, I'd rather stick with that instead of my code.