Comparing data from mdb and oracle databases

Class library usage, coding and language questions.
zealoussuresh
Posts: 5
Joined: Tue Sep 18, 2012 6:17 am

Comparing data from mdb and oracle databases

Post by zealoussuresh » Tue Sep 18, 2012 6:27 am

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

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

Re: Comparing data from mdb and oracle databases

Post by Support Team » Tue Sep 18, 2012 3:51 pm

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

zealoussuresh
Posts: 5
Joined: Tue Sep 18, 2012 6:17 am

Re: Comparing data from mdb and oracle databases

Post by zealoussuresh » Wed Sep 19, 2012 6:07 am

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

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA
Contact:

Re: Comparing data from mdb and oracle databases

Post by Support Team » Wed Sep 19, 2012 11:09 am

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