Need ideas on how to better approach the comparison of two different databases tables and show all the differences in a report.
Posted on 2016-10-07
Hello experts, I need your help,
I have two different databases: Oracle and Pervasive; each database have a table that it "supposed" to have the same information.
Both tables have the same columns (with diff. col. names). I need to pull out rows from the pervasive and compare each of the columns/rows with the oracle table; checking for differences in the data; data with no differences; and new data.
I need to create a report (using crystal rep 2013) that will display all the rows from the oracle table that were compared, highlighting all the differences found in the pervasive table, and at the end all new rows in pervasive not found in the oracle table.
I also need to create a table that will keep track of the rows from the pervasive table already compared with the oracle table, so next time the user run the application looking for differences, it will filter out all those rows. I am using MS Access database to help me with the comparison and to keep track of rows already compared.
All ideas are appreciated, Thank you!