cancel
Showing results for 
Search instead for 
Did you mean: 

Compare two databases

Highlighted
Occasional Contributor

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 1
Highlighted

RE: Compare two databases

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.


Best regards,
Alexey

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors