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
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.
2 Likes
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.
1 Like
I got the result i.e. total count
If i, want to get the complete query result. how to define.
please guide
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
after that i tried to compare the two results with if condition
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
Hi Dear,
How did you build the successful connection- I have an Appian Cloud server database ( dummy application so I am allowed to share screenshot and discuss ) trying to build a database test automation demo for our internal service offering purpose. I can’t establish the Appian server connection. Tried selecting - SQL, SQL database - all the option from drop down. I am very new and first time for database test automation using UiPath. If you can advise something, would appreciate. Thanks!