Compare datasource(expected data) with actual data in the database
I have a problem. I am putting data in a database(SQL developer) via a process which loads some XMLs in the database. I have the expected data in a datasource in parasoft soatest.
I want to compare the actual data in de database with the expected data in the datasource within parasoft soatest. How can I do that? What ways are there?
I know that you can use assertions. But the problem there is. For example. In 1 situation I have 2 records, in the database 2 records and in the datasource 2 records. But the assertions just compares both databaserecords with the first row of the datasource. Not the 1 record of the database with the first records of the database and the second record of the databse with the second record of the datasource. How can I solve this?
I would want to know this and also if there are another ways to compare database records with some expected data.
Thank you in advance!