Forum Discussion

ahmed_daniel's avatar
ahmed_daniel
Occasional Contributor
11 years ago

Comparing sql database files

Hi,



I am new to Test Complete and we have a product that gives results in sql database files and was wondering if I could get help in how to compare them.



I mean I need to make sure the newer version of program doesnt change the old results. 

I have done some text comparison but not sure how to do that with these files.

Also if there was a way to know where the differences were in the file would be really helpful. Not just a message in TestComplete that would say files are not equal.



Any kind of help would be really appreciated. 



Thanks,

Ahmed
  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    11 years ago
    http://support.smartbear.com/viewarticle/55620/



    Might be a good place to start.



    I do comparisons against DB records. But I do it through script. Create a connection, read in a record set (ie. it fires it an SQL query), compare that to a user supplied set of expected results. Works well.



    But if you're new to all this, probably best to start with the basics. So have a read through the above link and see if that gets you anywhere.