Is there something in Toad that can compare 2 schemas' tables and data. Then, for those rows of data that do not match, report and advise which columns do not match and write a report either to a grid or excel spreadsheet. I would want to know those problem rows and the value between the two that is different based on a specific matching key.
Compare Data Wizard can only compare 2 tables from different schemas and report what rows are different. But there is nothing that will compare all tables and all data in a schema. It shows the data and columns that have differences but it is not based off of a matching key. Not report with Excel is created.
WORKAROUND:
None.
Only option is to use the existing Compare Data Wizard which will give the general data differences but may still need further analysis.
STATUS:
Enhancement request ST61675 has been submitted to Development for consideration in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center