How to perform database testing

Task : compare two data bases - queri\y results

I like to connect two different schemas/db

after the connection is established

like to run the query in two different databases and need to compare the query results

please guide

@srikanth_bolisetty

You can use DatabaseActivities pack to configure from Packages and use the executeQuery activity for Select query. The output will be in Datatable format.

Once you get the output datatables for both Select queries and then you can perform DataTable operations to compare data.

Hope this helps your query.

1 Like

Thanks @singhonkar. for your guidance.
I am new to the UI Path, i will follow your suggestions and will try at my end.
is there any reference documents to follow. If yes, please guide.

I got the result i.e. total count

If i, want to get the complete query result. how to define.
please guide

Hi @srikanth_bolisetty,

I think you are getting only one table out put.but you want to compare two database query

Take another connect and execute query with second database the you will get output1
Do your operations like compare data table values or columns etc.

Regards,
Omkar P

Thanks for the suggestion @Reddy_Paluri
image
image

after that i tried to compare the two results with if condition


image

converted to string, but giving wrong result.

Did i missed anything?
please guide, how to overcome

Outpu1.Rows.Count=output2.Rows.Count

Thanks @Reddy_Paluri
It worked, missed the row count

If i want to compare column by column and row by row , how to define?
instead of just row count

can you please guide.
and is it possible to check more then one table?

If i want to compare column by column and row by row , how to define?
Output1.Columns.Count=output2.Columns.Count
Outpu1.Rows.Count=output2.Rows.Count

can you please guide.
and is it possible to check more then one table?
A)Not understand you mean another data table or database

Thanks for the suggestion.
Yes, another data table ex: lets say- each database having more than 1 data table
and to make it bit more detail check- is it feasible to compare the complete data table i.e. each value in cell

output1.Columns.Item(0)=output1.Columns.Item(0)
Column.Item(0) first column
You need to take two foreach row inside another foreach row loop through inside you can put if condition

Thanks for the suggestion!
I will try.

how to run more then 1 sql statemet from execute query activity./ is there any other activity to run more then one sql statemet
Please guide