cancel
Showing results for 
Search instead for 
Did you mean: 

Compare results from 2 different db

SOLVED
New Contributor

Compare results from 2 different db

i am not familiar with readyapi

i have 2 different dbs  and i want to compare specific records and fields between  these 2 dbs ,

not sure what is the correct way ,

should i create JDBC request OR DataSource of JDBC?

and also what is the correct way to compare between records? is there option to compare all the record and not each field separately and get the differences?

 

Thanks in advanced,

1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Re: Compare results from 2 different db

Hi,

 

Personally, I would create two JDBC Request Steps.  Then I would use a Groovy script step that 'pulls' in the results from the two JDBC Request steps and compares them using an assertion.

 

As for comparing the whole row or specific fields, I would say that depends on your requirement.

View solution in original post

2 REPLIES 2
Contributor

Re: Compare results from 2 different db

Hi,

 

Personally, I would create two JDBC Request Steps.  Then I would use a Groovy script step that 'pulls' in the results from the two JDBC Request steps and compares them using an assertion.

 

As for comparing the whole row or specific fields, I would say that depends on your requirement.

View solution in original post

New Contributor

Re: Compare results from 2 different db

Thanks @ChrisA 

can you please give me an example how to assert whole row/specific fields?

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors