Database testing using QTP?

[sdshah76]

If you are only doing database testing (comparing source data v/s. target data), Is QTP or any other automation tools really helpful?

[kunals]

Yes very much
As you can pass the SQL Query to the function which will return you the value from the Db and then just do a comparison n print the result in the text file for that field.
you can have then written in an excel file and then publish it as a result file.

Thanks,
Kunal.

[QA_GUY]

This is the very simple way to perform the dB testing with 3 VB Script functions,

- Expected Excel file (necessary)

1) Submit SQL
2) Write Output to Excel file (Actual Excel File)
3) FileComparision (Actual Vs. Expected)

DDOSHI

[Satyesha]

Hi DDOSHI,
Can you plz share these functions with Code ?