Forum Discussion

bach_ls's avatar
bach_ls
Occasional Contributor
6 years ago

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 featu...
  • anupamchampati's avatar
    anupamchampati
    6 years ago

    as per as I know we only have DBTables check and compare which will fetch the values from the database and will compare it with the saved data in TestComplete which as you said will not help you.

     

    You can export the sql query to txt file and compare those using TC or any file comparison tool. 

anupamchampati's avatar
anupamchampati
Frequent Contributor

as per as I know we only have DBTables check and compare which will fetch the values from the database and will compare it with the saved data in TestComplete which as you said will not help you.

 

You can export the sql query to txt file and compare those using TC or any file comparison tool. 

bach_ls's avatar
bach_ls
Occasional Contributor
6 years ago

Thank you for your reply.

In the end I had no other choice, than to do just that. It isn't perfect, but at least TestComplete's file comparison is much faster that my scripted way of comparing every line in ADO resultset... :)