Page 1 of 1

Comparing data from mdb and oracle databases

Posted: Tue Sep 18, 2012 6:27 am
by zealoussuresh
Hi Support Team,
How can I compare two tables from access database and oracle database respectively and spot out the differences using Ranorex. Do we have something like populating data to two datasets from a mdb and oracle respectively and compare the data sets ?

Thanks
Suresh

Re: Comparing data from mdb and oracle databases

Posted: Tue Sep 18, 2012 3:51 pm
by Support Team
Hi,

There is no special Ranorex method which automatically allows you to compare to result sets in Ranorex, but you can use all the functionality of the .Net Framework.
Do you use one of these databases as data connector or do you just want to compare the datasets in UserCode?

Regards,
Markus
Ranorex Support Team

Re: Comparing data from mdb and oracle databases

Posted: Wed Sep 19, 2012 6:07 am
by zealoussuresh
Hi Markus,
I am not using a dataconnector, but if I have 10 tables in access db and 10 tables in oracle database. I need to compare the data in those tables, how can I do it using user code ? Can you quote an example, because, I am new to .net as well. ? Can I use the datable.merge() method here ?

Thanks
Suresh

Re: Comparing data from mdb and oracle databases

Posted: Wed Sep 19, 2012 11:09 am
by Support Team
Hi,

Here is a link to a page where it is described you how can compare two data tables in C#: How to compare two datatables in c#.

Hope this helps,
Markus
Ranorex Support Team