Forum Discussion

sunsmile's avatar
sunsmile
Occasional Contributor
14 years ago

Compare two databases

Hi,

Is it possible to compare data from two different databases in TestComplete without writing ADO code?


I have added snapshot of data from one database in DB tables under stores section and also i have added snapshot of data with which i want to compare in DB tables.


How do i go about comparing these two snap-shots? I have aliased the column names to be same in both databases.


Please do let me know if you need more information here.

1 Reply

Sort By
  • AlexeyKolosov's avatar
    AlexeyKolosov
    Staff
    14 years ago

    Hi Pradeep,


    To compare values that are stored in a database with a baseline copy that is stored in your project as a DBTable element, you can use Database checkpoints. So, you cannot compare two different databases in this way.


    You need to use a scripting approach to accomplish your task. You need to connect to the databases, retrieve data and compare records one by one. Please see  Working With Databases and related articles for more information.