I would like to automate some steps in TransReplicator. Basically its a tool we used to do db comparison.
I am not able to fully record all my actions in that tool. I am getting below scripts in my expert view.
Window("TransReplicator").Window("New").Window("Ta ble/Column Comparison").WinObject("pbdw60").Click 471,43
Window("TransReplicator").Window("New").Window("Ta ble/Column Comparison").WinObject("pbdw60").Click 468,119
Kidnly help me how i can proceed with this.
Thanks in advance
What you mean by db comparison?
If it is anything related to retrieving data from database, look at using ADO objects.
QTP is not suggested to use on cutom tools which in turn have some functionality(ex : dbvisualizer, rapidsql..), instead try to hit the direct API and access the objects.
-- Here to Learn and share ---
Thanks Jonty for your reply..
db comparison - database comparison. Yes, the tool will work on sql/oracle db.
Is it possible can i go ahead with descriptive programming.
Could you pl help me on this.
I would not suggest it, because many of the actions QTP may not record or work even thru Descriptive pgming.
I have not tried complete db comparison so far, so not sure on how to do this, let's see if other forum users have done something like that.
Here I am assuming you want to compare data in two different DBs. Using ADO query the first DB and store the results in an array. Query the 2nd DB and store the results in another array.
and compare two arrays. read more about ADO and you will find lot of examples online.
- Czar [img]/images/graemlins/smile.gif[/img]