I have a table with the same name in 2 databases. The 2 tables don't have exactly the same structure but they have 2 fields in common, the primary key and another field that contains the description. The target table has more fields.
Maybe I misunderstand how the comparer works, but isn't it supposed to match records by the PK values and then compare only the columns that are in the dialog that are not PKs?
Thanks for reaching out - I have forwarded your input to our development team, we will reach out with the response to this issue shortly, thank you for your patience.
The select query performs a basic comparison by checking whether records exist or do not exist between the two tables.
In contrast, the Data Compare tool uses more complex comparison logic, and the results can significantly depend on the actual data within the tables. Factors such as collation differences, whitespace variations, and other data-level inconsistencies can affect the comparison outcome.
At this point, it is not possible to determine the exact cause of the discrepancy in your example, as we do not have access to the underlying data. Additionally, Data Compare provides a range of configuration options that can influence the results depending on how they are set.
In case you find it doable, please reach out through our support channel https://support.quest.com/ and submit a new support request where you can share with our teams underlying data for further analysis.
I downloaded the latest version of Toad as of right now, 26.2.0.44257 (64 bit), and I am happy to report that the compare is working properly, as expected. The numbers reported by the comparer match the numbers returned by my own queries.
So it seems that whatever issue was in version 8, it has been fixed in a newer version. That's great!
